This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
how_to:restore_a_backup_of_vpop3 [2010/02/04 13:57] – paul | how_to:restore_a_backup_of_vpop3 [2016/06/30 09:42] – [Version 2.6 or earlier] paul | ||
---|---|---|---|
Line 1: | Line 1: | ||
======How to Restore a backup of VPOP3====== | ======How to Restore a backup of VPOP3====== | ||
- | =====Version | + | 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 | ||
+ | If you just need to restore a database backup, see steps 4 to 7 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 | ||
- 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 vpop3**. When it prompts for the password enter the PostgreSQL master password - default **pgsqlpass**. | + | - 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 |
- | - Run **pgsql\bin\pg_restore -U postgres -d vpop3 DBBACK_< | + | - Run **pgsql\bin\pg_restore -U postgres |
- Start VPOP3 | - Start VPOP3 | ||
- | You may also want to [[Restore folder V3|Restore | + | =====Version 3 or 4===== |
+ | If you just need to restore | ||
- | =====Version 2.6 or earlier===== | + | To restore a [[backup_vpop3|full |
- | To restore a backup of VPOP3, | + | - 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]] | + | - Restore the files you made when you [[backup VPOP3|backed up VPOP3]] |
- Restore the registry backup you made as well by double-clicking on the .REG file you made | - 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. | + | - Reinstall VPOP3 into the location where you restored VPOP3. |
+ | - 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**. | ||
+ | - Run **pgsql\bin\pg_restore -U postgres -C -d postgres DBBACK-< | ||
+ | - Start VPOP3 | ||
+ | |||
+ | ====Increasing restore performance==== | ||
+ | When restoring the database backup it may take a very long time (depending on system performance, | ||
+ | |||
+ | Do not do this if the PostgreSQL server is used for other things as well! | ||
+ | |||
+ | In the **VPOP3\pgsql\data** folder: | ||
+ | - copy the '' | ||
+ | - edit the '' | ||
+ | - add the following to the bottom of the file: < | ||
+ | fsync = off | ||
+ | maintenance_work_mem = 128MB | ||
+ | full_page_writes = off | ||
+ | wal_buffers = 16MB | ||
+ | checkpoint_segments = 16</ | ||
+ | - save the file (as ' | ||
+ | - restart the ' | ||
+ | - run the restore procedure | ||
+ | - rename the '' | ||
+ | - copy the '' | ||
+ | - restart The' | ||
+ | Other articles: | ||
+ | |||
+ | - [[https:// | ||
{{tag> | {{tag> |