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.