Skip to content

Instantly share code, notes, and snippets.

@IslamWahid

IslamWahid/pg_dump_restore

Created January 3, 2022 08:52
Show Gist options
  • Save IslamWahid/d5b58081c2fa7d7d1295bcd7b32d7404 to your computer and use it in GitHub Desktop.
Save IslamWahid/d5b58081c2fa7d7d1295bcd7b32d7404 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Migration CheatSheet
Raw
pg_dump_restore
pg_dump -h {HOST} -U {USER} -W --verbose -Fc --no-acl {DB_NAME} > ./{FILE_NAME}.psql
pg_restore -h {HOST} -U {USER} -W --exit-on-error --verbose --no-acl --dbname={DB_NAME} < ./{FILE_NAME}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment