PSCS Wiki

User Tools

Site Tools

Trace:
how_to:restore_a_backup_of_vpop3

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
how_to:restore_a_backup_of_vpop3 [2012/02/15 12:32] – paulhow_to:restore_a_backup_of_vpop3 [2012/08/17 10:18] – paul
Line 1: Line 1:
 ======How to Restore a backup of VPOP3====== ======How to Restore a backup of VPOP3======
 +The instructions below are to restore a full backup. You may also be able to [[recover deleted messages]] if you do not need to restore a full backup.
 +
 =====Version 5 or later===== =====Version 5 or later=====
 If you just need to restore a database backup, see steps 4 to 6 below. If you just need to restore a database backup, see steps 4 to 6 below.
Line 25: Line 27:
   - Run **pgsql\bin\pg_restore -U postgres -C -d postgres 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**. Note that during this step you may see a couple of errors which are not important: there may be an error about the database already existing, and also an error that the 'plpgsql' language is already installed. (Each of these errors may have several lines in the output). If there are lots of errors, then there may be a problem and you should contact support@pscs.co.uk.   - Run **pgsql\bin\pg_restore -U postgres -C -d postgres 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**. Note that during this step you may see a couple of errors which are not important: there may be an error about the database already existing, and also an error that the 'plpgsql' language is already installed. (Each of these errors may have several lines in the output). If there are lots of errors, then there may be a problem and you should contact support@pscs.co.uk.
   - Start VPOP3   - Start VPOP3
- 
-You may also want to [[Restore folder V3|Restore a single user's mailbox or mail folder]] 
  
 ====Increasing restore performance==== ====Increasing restore performance====
Line 43: Line 43:
 checkpoint_segments = 16</code> checkpoint_segments = 16</code>
   - save the file (as 'postgresql.conf' in the VPOP3\pgsql\data folder)   - save the file (as 'postgresql.conf' in the VPOP3\pgsql\data folder)
-  - restart the 'PostgreSQL-VPOP3' (or 'PostgreSQL') service+  - restart the 'VPOP3DB' (or 'PostgreSQL-VPOP3', or 'PostgreSQL') service
   - run the restore procedure   - run the restore procedure
   - rename the ''postgresql.conf' file to 'postgresql.conf.restore''   - rename the ''postgresql.conf' file to 'postgresql.conf.restore''
   - copy the ''postgresql.conf.normal'' file back to ''postgresql.conf''   - copy the ''postgresql.conf.normal'' file back to ''postgresql.conf''
-  - restart The 'PostgreSQL-VPOP3' (or 'PostgreSQL') service+  - restart The'VPOP3DB' (or 'PostgreSQL-VPOP3', or 'PostgreSQL') service
 =====Version 2.6 or earlier===== =====Version 2.6 or earlier=====
 To restore a backup of VPOP3,  To restore a backup of VPOP3, 
how_to/restore_a_backup_of_vpop3.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki