Backups¶
Barman¶
Barman (Backup and Recovery Manager) is an open-source administration tool for disaster recovery of PostgreSQL servers written in Python.
It allows your organisation to perform remote backups of multiple servers in business critical environments and help DBAs during the recovery phase.
Install pg_dump¶
sudo apt-get install postgresql-client
How To Backup and Restore PostgreSQL Database Using pg_dump and psql¶
Use pg_dump to get backup:
$ pg_dump -U <USER> -h <REMOTE-HOST> -d <DATABASE-NAME> > <DB-DATA.SQL>
$ pg_dump -U postgres -h 127.0.0.1 -d redmine > redmine.sql
Use psql to restore backup:
$ psql -U <USER> -h <REMOTE-HOST> -d <DATABASE-NAME> -f <DB-DATA.SQL>
$ psql -U postgres -h 172.17.0.2 -d redmine -f redmine_backup_pg_dump.sql