Save and restore local PostgreSQL development database

Save the psql database state as per stackoverflow.com/questions/37984733/postgresql-database-export-to-sql-file with our web/bin/pg_dump helper:

web/bin/pg_dump tmp.dump

Then to restore it later with web/bin/pg_restore:

web/bin/pg_restore tmp.dump

stackoverflow.com/questions/2732474/restore-a-postgres-backup-file-using-the-command-line

 Ancestors

 Incoming links

Download Heroku database and restore it locally