Databases backup in PostgreSQL cluster

[koraykutanoglu]

hi, I have reviewed and tested many tools for backing up PostgreSQL cluster. It all turned out to be quite complex and difficult. Those who do not want to deal with these can take a look at the script file I prepared. You can easily send your backups to your SFTP server by setting the variables. In terms of security, it runs on script cluster machines. The script is set as cron on all cluster machines. When the script file runs, it checks whether it has the keepalived IP. If the keepalived IP address is on that machine, backup starts. Then a backup is sent to the SFTP server via the port we set. Local backups are then deleted, and in addition, if there is a backup older than the day we set on the target server, it is automatically deleted. Backups are taken with pg_dumpall and parsed into files. In other words, a single backup file is parsed and converted into database backups. Simple but practical.

https://github.com/koraykutanoglu/postgresql-cluster-databases-backup