Skip to content

Instantly share code, notes, and snippets.

@mrrooijen

mrrooijen/pg_dump_restore

Last active April 9, 2016 16:09
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrrooijen/93483cef048277340b99aaa41e422835 to your computer and use it in GitHub Desktop.
Save mrrooijen/93483cef048277340b99aaa41e422835 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres Dump/Restore From/To RDS/Compose
Raw
pg_dump_restore
export HOSTNAME_A=todo
export PORT_A=todo
export DBNAME_A=todo
export USERNAME_A=todo
export HOSTNAME_B=todo
export PORT_B=todo
export DBNAME_B=todo
export USERNAME_B=todo
pg_dump --verbose --format c \
-h $HOSTNAME_A -p $PORT_A -U $USERNAME_A -d $DBNAME_A -f $DBNAME_A.dump
pg_restore --verbose --clean --no-acl --no-owner \
-h $HOSTNAME_B -p $PORT_B -U $USERNAME_B -d $DBNAME_B $DBNAME_A.dump
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment