17

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?

  • 2
    Those snapshots are probably physical backups, i.e. file-system level. If so, they're probably quite a bit bigger than the dump, and if Amazon uses a patched PostgreSQL (as is likely) might not be compatible with regular community PostgreSQL's on-disk format anyway. pg_dump is likely your best bet. – Craig Ringer Mar 14 '14 at 23:17
8

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

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.