Hey, folks. We just upgraded our Heroku app database from the Shared add-on to the new Heroku Postgres add-on. As you may know, the Shared add-on is being phased out in September... so Heroku is beginning to migrate everyone who's still using it.
Since we did this, however, we're unable to back our database up to Amazon S3. (We're using the heroku_s3_backup gem via daily cron to backup.) The heroku_s3_backup gem isn't working because of a version mismatch in the pg_dump tool. The Bamboo stack uses version 8.x of Postgres and the new Heroku Postgres add-on uses version 9.1. Apparently pg_dump is very sensitive to version changes, so it fails when attempting to dump data from a 9.1 database using an 8.x instance of the dump tool. (Reason #2234 I'm not a fan of Postgres). Can you guys recommend any workaround that would allow us to backup our database to S3 which does not require upgrading to the Cedar stack (we can't do that yet, unfortunately) or backing up locally (we want to run this in the cloud from the app itself)? Thanks, Patrick -- SD Ruby mailing list [email protected] http://groups.google.com/group/sdruby
