Post thumbnail of How to restore a postgresql database from dumpall backup
23 October 2009
Continue reading How to restore a postgresql database from dumpall backup

How to restore a postgresql database from dumpall backup

If your dump was performed with the “–clean” option, you can skip the reinitializing of your databases to avoid duplicating data. This option, used with the “pg_dumpall” command will cause the restore to clean out all the objects in the database before performing the restore. If you didn’t include this option, then just delete the data directory and reinitialize the database as shown below.

Post thumbnail of Easy backup and restore of postgresql databases
10 February 2009
Continue reading Easy backup and restore of postgresql databases

Easy backup and restore of postgresql databases

For getting a copy of a live system’s postgres databases onto a development platform, it’s easiest to just dump the whole thing and restore it on the dev machine.

Share this:
  • Digg
  • Facebook
  • Reddit
  • LinkedIn
  • Google Bookmarks
Powered by Wordpress   |   Lunated designed by ZenVerse