Differences

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

--- how_to:restore_a_database_backup [2010/09/21 09:29] – created paul
+++ how_to:restore_a_database_backup [2013/09/23 14:35] – [Restore a database backup] paul
@@ Line 1: / Line 1: @@
 ======Restore a database backup======
+By default VPOP3 makes a daily backup of the VPOP3 database to a file 'DBBACK-n.DMP' in the VPOP3 installation directory (it is possible to [[reference:database backups|change this in the settings]]). These are cycled on a weekly basis so you will usually have the last seven days' worth of backups. These can be useful if the database gets damaged somehow.
 If you have a valid backup of the PostgreSQL database used by VPOP3, you can restore it by performing the following steps:
+=====VPOP3 v5 or later=====
+  - Open a command prompt, and go to the VPOP3 directory
+  - If you are restoring the backup over an existing VPOP3 database (especially if the database files are damaged) you will need to DROP the database first.
+    - To do this, run pgsql\bin\dropdb -U postgres -p 5433 vpop3. When it prompts for the password enter the PostgreSQL master password - default **pgsqlpass**.
+  - Run pgsql\bin\pg_restore -U postgres -C -p 5433 -v -j 4 -d postgres <filename> where <filename> is the database backup you want to restore. When it prompts for a password enter the PostgreSQL master password - default **pgsqlpass**
+=====VPOP3 v3 or v4=====
   - Open a command prompt, and go to the VPOP3 directory
   - If you are restoring the backup over an existing VPOP3 database (especially if the database files are damaged) you will need to DROP the database first.
-    - To do this, run pgsql\bin\dropdb -U postgres vpop3. When it prompts for the password enter the PostgreSQL master password - default pgsqlpass.
+    - To do this, run pgsql\bin\dropdb -U postgres vpop3. When it prompts for the password enter the PostgreSQL master password - default **pgsqlpass**.
-    - Then you will need to recreate the database - run pgsql\bin\createdb -E SQL_ASCII -O vpop3 -U postgres vpop3
+  - Run pgsql\bin\pg_restore -U postgres -C -v -d postgres <filename> where <filename> is the database backup you want to restore. When it prompts for a password enter the PostgreSQL master password - default **pgsqlpass**
-  - Run pgsql\bin\pg_restore -U postgres -C -d vpop3 DBBACK-<number>.DMP where <number> is the latest number of the database backup made by VPOP3. When it prompts for a password enter the PostgreSQL master password - default pgsqlpass

PSCS Wiki

User Tools

Site Tools

Differences

Page Tools