-
PostgreSql how to sperate data directory for data dir
•
When installing PostgreSQL, it defaults to creating its data directory in /var/lib/postgresql. For better performance, reliability, and management, it is often recommended to relocate the PostgreSQL data directory to a dedicated disk or separate mount point. This can help with I/O performance, backup management, and isolation of database operations from the rest of the…
-
Using percona xtrabackup for backup
•
taking backup percona xtrabackup is consider a hot backup that backup the whole data directory with its redo logs and also it will take backup of the my.cnf to take backup we have already setup directory for backup mkidr backup to take the backup we will use the below command which will also compress…