Differences

This shows you the differences between two versions of the page.

--- how_to:database_maintenance [2013/09/09 10:17] – [Alternative to backup/restore] paul
+++ how_to:database_maintenance [2018/04/17 15:33] – [Steps for backup/restore] paul
@@ Line 27: / Line 27: @@
   * Stop the VPOP3 service, //not// the VPOP3DB service
   * Go to a command prompt in the VPOP3 directory
-  * Backup the database to a file, eg 'database.dmp', using, eg: **pgsql\bin\pg_dump -p 5433 -v -F c -U vpop3 -f database.dmp vpop3**
+  * Backup the database to a file, eg 'database.dmp', using, eg: **pgsql\bin\pg_dump -p 5433 -v -F c -U postgres -f database.dmp vpop3**
-  * Remove the old database using **pgsql\bin\dropdb -U postgres -p 5433**
+  * Make sure there were no errors reported during the backup!
-  * Restore the database backup using, eg: **pgsql\bin\pg_restore -U -v -j 4 postgres -p 5433 -C -d postgres database.dmp**
+  * Remove the old database using **pgsql\bin\dropdb -U postgres -p 5433 vpop3**
+  * Restore the database backup using, eg: **pgsql\bin\pg_restore -v -j 4 -U postgres -p 5433 -C -d postgres database.dmp**
   * Restart the VPOP3 service

PSCS Wiki