How to Dump and Restore Postgres - maple-dev-team/docs GitHub Wiki

Requirements

pg cli

Dumb

pg_dump -v -h nexterp.cxfr2wnchlni.ca-central-1.rds.amazonaws.com -U masterp -F c nexterp > prod.tar.gz

Restore

Before the restore, make sure to delete nexterp database and create again with the same name

pg_restore -v -h dev-server-next-erp.cxfr2wnchlni.ca-central-1.rds.amazonaws.com -c -C -O -U postgres --dbname=nexterp prod.tar.gz