Patrick, Did you ever figure this out? I have the same issue using a similar gem (mesanyachi/backup) and have a version mismatch with the Bamboo stack and the target database on Ivory.
Chris On Thursday, August 16, 2012 2:55:18 PM UTC-4, Patrick Crowley wrote: > > 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
