1. Create a Snapshot of the database you want to download
2. In the "Snapshots" Section, click "Restore" on the Snapshot. This will create a new database from the snapshot.
3. From your Console, enter a command, pg_dump -h henry-june-12.cmkhjgf43.eu-central-1.rds.amazonaws.com -U root -f dump.sql stock_observer_production
henry-june-12.cmkhjgf43.eu-central-1.rds.amazonaws.com is the URL for the database
-h, -U and -f are unknown commands that are apparently umportant
"root" here is the username on the database
dump.sql is the name you will give to the data file you will save
stock_observer_production is the name of the database itself
After that you will be asked for your password to the database.
Finally, you will get a dump of your database saved in a folder, e.g. dump.sql
(Now you can do stuff like, change it from an SQL to a CSV file using the steps detailed in the previous blog post)| Back