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.

Powered by Wordpress   |   Lunated designed by ZenVerse