I'm trying to figure out the best plan of attack for making a nightly copy of our Heroku PostgreSQL production database to our local development environment.

The database is rather large and grows at roughly 250,000 rows per day. Ideally the solution would be an incremental method and only restore the previous days changes.

Our development environment is also Postgres running on OSX.

Any and all help is appreciated.

  • For normal non-hosted PostgreSQL you'd use WAL archiving/streaming replication. – Craig Ringer Sep 15 '15 at 10:37
  • Thanks for the comment. Would this apply to my situation being that my source database is hosted and my target database is non-hosted? Looks like I have some reading to do today. :) – contact411 Sep 16 '15 at 0:12
  • As far as I can tell Heroku doesn't let you get WAL out of their system, and you'd need an identical binary-compatible Pg and a matching base backup. You might have to use dumps, or a trigger based replication system like Bucardo. – Craig Ringer Sep 16 '15 at 5:46

Your Answer

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

Browse other questions tagged or ask your own question.