To do a backup, make sure that you have bundle installed the gems.
Then, run ./backup. This will take railsthemes-production and copy it to a new bucket called railsthemes-prod-backup-YYYYMMDD-HHMMSS.
To get a dump of the current production database:
s3-backups> heroku pgbackups --app railsthemes
ID | Backup Time | Size | Database
-----+---------------------+--------+-------------
a092 | 2012/05/24 20:00.41 | 31.3KB | DATABASE_URL
a099 | 2012/05/31 20:00.54 | 32.4KB | DATABASE_URL
a106 | 2012/06/07 20:01.54 | 43.2KB | DATABASE_URL
a113 | 2012/06/14 20:01.49 | 47.8KB | DATABASE_URL
a120 | 2012/06/21 20:02.03 | 56.2KB | DATABASE_URL
a124 | 2012/06/25 20:01.59 | 56.4KB | DATABASE_URL
a125 | 2012/06/26 20:01.53 | 56.4KB | DATABASE_URL
a126 | 2012/06/27 20:01.52 | 58.3KB | DATABASE_URL
a127 | 2012/06/28 20:01.55 | 58.3KB | DATABASE_URL
a128 | 2012/06/29 20:01.56 | 58.4KB | DATABASE_URL
a129 | 2012/06/30 20:01.54 | 58.4KB | DATABASE_URL
a130 | 2012/07/01 20:01.45 | 58.4KB | DATABASE_URL
s3-backups> heroku pgbackups:capture --app railsthemes
SHARED_DATABASE (DATABASE_URL) ----backup---> b131
Capturing... done Storing... done
s3-backups> heroku pgbackups:url b131 --app railsthemes "url"
s3-backups> wget "url"
Could create a script for this pretty easily when we want to do this automatically