Editing PostgreSQL Backups and Migration (section)

=== AWS RDS PostgreSQL ===

* Change your database RDS instance security group to allow your machine to access it.
** Add your ip to the security group to access the instance via Postgres. 
** '''AWS Management Console''' > '''Services''' > '''Database''' > '''RDS''' > '''Database Instances''' > ''Click on an instance name to view its details''
** '''Connectivity & Security''' tab > '''Security''' > '''VPC security groups''' > ''Click on group name''
** '''Inbound Rules''' tab > '''Edit inbound rules''' > ''Add IP of local machine''
* In a local terminal, 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>`
** Public DNS is available via '''RDS Management Console''' > '''Database Instances''' > ''Click on an instance name to view its details''
** '''Connectivity & security''' > '''Endpoint & port''' > '''Endpoint''' > The public DNS. 
** The port number (default port for PostgreSQL is 5432) is listed below. <ref>[https://gist.github.com/syafiqfaiz/5273cd41df6f08fdedeb96e12af70e3b How to copy production database on AWS RDS(postgresql) to local development database] - GitHub Gist</ref>