Skip to content

Instantly share code, notes, and snippets.

@sibinx7

sibinx7/database.md

Last active October 10, 2017 17:59
Show Gist options
  • Save sibinx7/a6b1052cd32bcf610aee2c4c32fbafff to your computer and use it in GitHub Desktop.
Save sibinx7/a6b1052cd32bcf610aee2c4c32fbafff to your computer and use it in GitHub Desktop.
Download ZIP
Database helpers
Raw
database.md

Postgres

Permission issues

  • Goto etc/postgres/postgresql-version/pg_hba.config
  • Change peer/md5/anything to trust

Dump postgresql Database

pg_dump -Fc -U <username> -d <database> > /<path><filename>

Heroku

Reset Heroku database
heroku pg:reset DATABASE
Download Heroku Backup
heroku pg:backups:capture --app <APP NAME>
$ heroku pg:backups:download

https://devcenter.heroku.com/articles/heroku-postgres-backups

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment