PostgreSQL Dump/Restore (data only)

README.md

Create backup on the source database

Note:

Owner and privileges are excluded.

pg_dump -U src_db_user -h src-db.example.com -d src_db_name --no-owner --no-privileges -F c -f mybackup-yyyMMddHHmmss.dump

Restore backup to the destination database

Create backup first before restoring

pg_dump -U dst_db_user -h dst-db.example.com -d dst_db_name --no-owner --no-privileges -F c -f backup_before_restore-yyyMMddHHmmss.dump

Restore

pg_restore -U dst_db_user -h dst-db.example.com -d dst_db_name --no-owner --no-privileges --disable-triggers mybackup-yyyMMddHHmmss.dump