How to Import/restore data into Heroku postgres database from a dump file

On September 24, 2012, in Heroku, PostgreSql, Rails, by Dipin Krishna

I was working on a rails app and i had a huge amount of data in my local Postgres database. This is what i did to import data into the database at heroku from a dump file of my local database.

Tagged with:  

PostgreSQL: Dump(Backup) and Restore a Database

On August 21, 2012, in DB, PostgreSql, by Dipin Krishna

Backup pg_dump is the utility i am using for backing up a PostgreSQL database. It makes consistent backups even if the database is being used concurrently. pg_dump does not block other users accessing the database (readers or writers). Restore pg_restore is the utility i am using for restoring a PostgreSQL database from an archive created […]

Tagged with:  

Search