170
edits
Changes
Jump to navigation
Jump to search
→Server Backup Policy
6-16-2016: Above method is a very simple backup. We should do something like using
[https://www.digitalocean.com/community/tutorials/how-to-back-up-restore-and-migrate-postgresql-databases-with-barman-on-centos-7 barman] which provides enterprise backup control.
==== PostgreSQL config backup ====
Backup these files
/var/postgresql/data/postgresql.conf : This file is read by psql on server startup.
/var/postgresql/data/postgresql.auto.conf : This is also read at server startup. Should not be edited manually. Config options are set with ALTER SYTEM command.
/var/postgresql/data/pg_hba.conf Contains : psql user account information.
/var/postgresql/data/pg_ident.conf : Contains mapping from psql user accounts to system accounts.
We probably don't need last two files. Better to recreate them when restoring the database.
[[category:McNair Admin]]
