Grab and Store PG Backup from Heroku

grab_and_store_heroku_pg_backup.markdown

Exporting from Heroku

heroku pg:backups capture && curl -o ~/Desktop/app_latest.dump `heroku pg:backups public-url`

Importing locally

pg_restore --verbose --clean --no-acl --no-owner -h localhost -d app_db ~/Desktop/app_latest.dump

Export and import including dropping and creating the DB locally

dropdb butternutbox_development && rake db:create && heroku pg:backups capture && curl -o ~/Desktop/app_latest.dump `heroku pg:backups public-url` && pg_restore --verbose --clean --no-acl --no-owner -h localhost -d butternutbox_development ~/Desktop/app_latest.dump

Exporting to CSV

COPY people TO '/tmp/people.csv' DELIMITER ',' CSV HEADER;

Exporting JSON from Postgres

copy (select array_to_json(array_agg(row_to_json(t)))
from (
  select * from people
) t) to '/tmp/people.json' CSV QUOTE '$';

Exporting locally

pg_dump -Fc --no-acl --no-owner -h localhost db-dev > ~/Desktop/db-dev.dump

Importing into Dokku (Dump File)

dokku postgres:import global-invest-her < /root/gih_latest.dump