-
Notifications
You must be signed in to change notification settings - Fork 0
How to Dump and Restore Postgres
Leonardo de Santana Ornelas edited this page Mar 14, 2022
·
2 revisions
pg cli
pg_dump -v -h nexterp.cxfr2wnchlni.ca-central-1.rds.amazonaws.com -U masterp -F c nexterp > prod.tar.gz
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