Danil Kozyatnikov Danilka

## how-to-copy-remote-postgresql-to-local.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                Danilka
                / how-to-copy-remote-postgresql-to-local.md
            
            
              Last active
              December 27, 2019 18:21
                — forked from syafiqfaiz/how-to-copy-aws-rds-to-local.md
            
              
                How to copy production database on AWS RDS(postgresql) to local development database.
              
          
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


Clean the existing database by recreating it.

psql -U "<my username>" -d <some local database name> -c "DROP DATABASE <database name>;"
psql -U "<my username>" -d <some local database name> -c "CREATE DATABASE <database name>;"


The dump file might contain references to the original user priveleges. In this case you will have to do one of the two things:

Create the same user locally: psql -U "<my username>" -d <database name> -c "CREATE USER <original postgresql username> SUPERUSER;"
Replace all mentions of the old username with a new one in your <name of dump file .sql>