Cpanel | TECHIES WORLD

How to configure password expiry for PostgreSQL user

PostgreSQL providing the option to configure password expiry for users. The following query can be used to configure password expiry.

We can remount the mounted drives as read/write using the following command. Where device-name and mount-point need to be replaced

Sometime it may require to to grant access to binlog for a user other that superuser in MySQL. We can

MySQL used a plugin called validate_password which setup the password policy level. There are three password policy levels in MySQL

We can use pg_drop_replication_slot to delete replication slot in PostgreSQL. Where NAME need to be replaced with the name of

inventory_hostname is the one which configured in the ansible inventory file (eg: /etc/ansible/hosts). It can be an IP address or

Sometimes we might get the message "device busy" on trying umount. This is because some processes are still accessing those

August 11, 2021 admin 0 Comments

We can configure the bash in such a way that it doesn't prompt for a password during PostgreSQL connections via

We can use COPY command to in PostgreSQL to export data from table to csv file. Where, That's all…

To loop through a comma separated variable in bash, need cut the elements first and then iterate over each. Sample

We can use the following query to get the data count for all tables in MySQL database. Where dbname need