Easy usage of postgresql on heroku ref: http://qiita.com/items/1f63e0993ed15d19f5fe

file0.txt

// Check available addons
% heroku addons:list

// Install postgres
% heroku addons:add heroku-postgresql

// Check addons in your repository
% heroku addons
=== hogehogehogehoge Configured Add-ons
heroku-postgresql:dev  HEROKU_POSTGRESQL_TEAL

file1.txt

% heroku config    === hogehogehogehoge Config Vars
FACEBOOK_APP_ID:            000000000000000
FACEBOOK_SECRET:            000000000000000000
HEROKU_POSTGRESQL_TEAL_URL: postgres://userhoge:passwordfuga@servernamefunya:portgowa/dbnamechowa

file10.txt

% curl -o heroku.dump 'https://s3.amazonaws.com/hkpgbackups/hogehoge@heroku.com/b001.dump?AWSAccessKeyId=fugafuga&Expires=hunyahunya&Signature=wachawacha'  % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                 Dload  Upload   Total   Spent    Left  Speed
100  1416  100  1416    0     0    988      0  0:00:01  0:00:01 --:--:--  1931
% ls
heroku.dump  <- this!!

file11.txt

% pg_restore --verbose --clean --no-acl --no-owner -h localhost -U [username] -d [dbname] [backup file name]

file2.txt

% heroku addons:add pgbackups
Adding pgbackups on powerful-castle-8258... done, v12 (free)
You can now use "pgbackups" to backup your databases or import an external backup.
Use `heroku addons:docs pgbackups` to view documentation.

file3.txt

% heroku addons:docs pgbackups
Opening pgbackups docs... done

file4.txt

% heroku addons:docs heroku-postgresql
Opening heroku-postgresql docs... done

file5.txt

% heroku pgbackups:capture
 !    Unknown database. Valid options are: HEROKU_POSTGRESQL_TEAL_URL

file6.txt

% heroku pgbackups:capture HEROKU_POSTGRESQL_TEAL_URL

HEROKU_POSTGRESQL_TEAL_URL  ----backup--->  b001

Capturing... done
Storing... done

file7.txt

% heroku pgbackups
ID    Backup Time          Status                          Size   Database
----  -------------------  ------------------------------  -----  --------------------------
b001  2013/04/04 00:49.18  Finished @ 2013/04/04 00:49.25  1.4KB  HEROKU_POSTGRESQL_TEAL_URL

file8.txt

% heroku pgbackups:restore HEROKU_POSTGRESQL_TEAL_URL b001HEROKU_POSTGRESQL_TEAL_URL  <---restore---  b001
                                            HEROKU_POSTGRESQL_TEAL_URL
                                            2013/04/04 00:49.18
                                            1.4KB


 !    WARNING: Destructive Action
 !    This command will affect the app: powerful-castle-8258
 !    To proceed, type "appidhoge" or re-run this command with --confirm appidhoge


> appidhoge


Retrieving... done
Restoring… done

file9.txt

% heroku pgbackups:url b001              "https://s3.amazonaws.com/hkpgbackups/hogehoge@heroku.com/b001.dump?AWSAccessKeyId=fugafuga&Expires=hunyahunya&Signature=wachawacha"