Skip to content

Instantly share code, notes, and snippets.

@palewire

palewire/pg_to_rds.sh

Last active July 16, 2018 19:45
Show Gist options
  • Save palewire/0fcdea3559aa4ab6a74fc5434e11c5c3 to your computer and use it in GitHub Desktop.
Save palewire/0fcdea3559aa4ab6a74fc5434e11c5c3 to your computer and use it in GitHub Desktop.
Download ZIP
Migrate PostgreSQL databases to Amazon RDS
Raw
pg_to_rds.sh
pg_dump -Fc --no-acl --no-owner -h localhost -U <YOUR LOCAL DATABASE USER> <YOUR LOCAL DATABASE NAME> > <YOUR LOCAL DATABASE NAME>.dump;
pg_restore -v -h <YOUR RDS IP ADDRESS> -U <YOUR RDS DATABASE USER> -d <YOUR RDS DATABASE NAME> <YOUR LOCAL DATABASE NAME>.dump;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment