Changes

Jump to navigation Jump to search
573 bytes added ,  12:39, 16 June 2016
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]]

Navigation menu