patternsqlModerate
Get postgres snapshot from Amazon RDS
Viewed 0 times
postgressnapshotgetamazonrdsfrom
Problem
I can not find a simple way to get a copy of the nightly backup I take of my Amazon RDS postgres instance so I can restore it on my local machine to play with.
Right now I'm doing a pg_dump when I need a copy, but it would be nicer (and faster, presumably) to be able to download those snapshots. Is this not possible?
Right now I'm doing a pg_dump when I need a copy, but it would be nicer (and faster, presumably) to be able to download those snapshots. Is this not possible?
Solution
You can't download a snapshot from RDS you have to use a tool like pg_dump
This has already been answered multiple times on regular Stack Overflow:
https://stackoverflow.com/questions/14916899/download-rds-snapshot
This has already been answered multiple times on regular Stack Overflow:
https://stackoverflow.com/questions/14916899/download-rds-snapshot
Context
StackExchange Database Administrators Q#60982, answer score: 10
Revisions (0)
No revisions yet.