User Tools

Site Tools


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
how_to:restore_a_backup_of_vpop3 [2012/08/17 09:18] paulhow_to:restore_a_backup_of_vpop3 [2018/11/14 10:45] (current) – external edit 127.0.0.1
Line 3: Line 3:
  
 =====Version 5 or later===== =====Version 5 or later=====
-If you just need to restore a database backup, see steps 4 to below.+If you just need to restore a database backup, see steps 4 to below.
  
 To restore a [[backup_vpop3|full backup of VPOP3]],  To restore a [[backup_vpop3|full backup of VPOP3]], 
   - If VPOP3 is already installed, make sure VPOP3 is shut down before starting the restore process   - If VPOP3 is already installed, make sure VPOP3 is shut down before starting the restore process
   - Restore the files you made when you [[backup VPOP3|backed up VPOP3]] - do //NOT// restore anything in the **VPOP3\pgsql** folder tree   - Restore the files you made when you [[backup VPOP3|backed up VPOP3]] - do //NOT// restore anything in the **VPOP3\pgsql** folder tree
-  - Restore the registry backup you made as well by double-clicking on the .REG file you made 
   - Reinstall VPOP3 into the location where you restored VPOP3. This should reinstall the PostgreSQL database system. //Do not start VPOP3 at this time//   - Reinstall VPOP3 into the location where you restored VPOP3. This should reinstall the PostgreSQL database system. //Do not start VPOP3 at this time//
   - Open a command prompt, and go to the VPOP3 directory   - 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 <port number> vpop3**. When it prompts for the password enter the PostgreSQL master password - default **pgsqlpass**. (<port number> is usually 5433)   - 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 <port number> vpop3**. When it prompts for the password enter the PostgreSQL master password - default **pgsqlpass**. (<port number> is usually 5433)
-  - Run **pgsql\bin\pg_restore -U postgres -p <port number> -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**. (<port number> is usually 5433). 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 -p <port number> -v -C -d postgres DBBACK-<number>.DMP** where <number> is the latest number of the database backup made by VPOP3 (check the file timestamps). When it prompts for a password enter the PostgreSQL master password - default **pgsqlpass**. (<port number> is usually 5433). 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
  
Line 48: Line 47:
   - copy the ''postgresql.conf.normal'' file back to ''postgresql.conf''   - copy the ''postgresql.conf.normal'' file back to ''postgresql.conf''
   - restart The'VPOP3DB' (or 'PostgreSQL-VPOP3', or 'PostgreSQL') service   - restart The'VPOP3DB' (or 'PostgreSQL-VPOP3', or 'PostgreSQL') service
-=====Version 2.6 or earlier===== + 
-To restore a backup of VPOP3,  +====Related articles==== 
-  - If VPOP3 is already installed, make sure VPOP3 is shut down before starting the restore process + 
-  - Restore the files you made when you [[backup VPOP3|backed up VPOP3]] +  - [[https://support.pscs.co.uk/staff/index.php?/Knowledgebase/Article/Edit/38|Restore backup on Version 2.6 or earlier]]
-  - Restore the registry backup you made as well by double-clicking on the .REG file you made +
-  - Reinstall VPOP3 into the location where you restored VPOP3+
  
 {{tag>restore backup}} {{tag>restore backup}}
how_to/restore_a_backup_of_vpop3.1345195126.txt.gz · Last modified: 2018/11/14 10:44 (external edit)