Skip to content

Instantly share code, notes, and snippets.

@letsgogeeky

letsgogeeky/how-to-copy-aws-rds-to-local.md

Forked from syafiqfaiz/how-to-copy-aws-rds-to-local.md
Last active April 1, 2019 15:06
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save letsgogeeky/9f2ec7478f814a61e2cfc147681ad5f7 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save letsgogeeky/9f2ec7478f814a61e2cfc147681ad5f7 to your computer and use it in GitHub Desktop.
Download ZIP
How to copy production database on AWS RDS(postgresql) to local development database.
Raw
how-to-copy-aws-rds-to-local.txt
1) Change your database RDS instance security group to allow your machine to access it.
Add your ip to the security group to acces the instance via Postgres.
2) Make a copy of the database using pg_dump
`$ pg_dump -h <public dns> -U <my username> -f <name of dump file .sql> <name of my database>`
you will be asked for postgressql password.
a dump file(.sql) will be created
3) restore that dump file to your local database.
but you might need to drop the database and create it first
`$ psql -U <postgresql username> -d <database name> -f <dump file that you want to restore>`
the database is restored
ref
1) http://stackoverflow.com/questions/31881786/how-to-pg-dump-an-rds-postgres-database
2) http://www.thegeekstuff.com/2009/01/how-to-backup-and-restore-postgres-database-using-pg_dump-and-psql/
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment