User Tools

Site Tools


how_to:restore_folder_-_v5

Differences

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

Link to this comparison view

Next revision
Previous revision
how_to:restore_folder_-_v5 [2012/07/09 10:59] – created paulhow_to:restore_folder_-_v5 [2018/11/14 10:45] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ======Restore selected mail folders or mailbox in VPOP3 v5 or later====== ======Restore selected mail folders or mailbox in VPOP3 v5 or later======
 +(This option is only available in VPOP3 Enterprise)
  
-First - if the problem is that messages were deleted very recently (the default is within 3 days), you can probably use the Undelete feature in VPOP3.+First - if the problem is that messages were deleted very recently (the default is within 3 days), you can probably use the [[Undelete]] feature in VPOP3.
  
 If the messages were deleted longer ago than that, you can use the partial restore facility in VPOP3 version 5 or later. If the messages were deleted longer ago than that, you can use the partial restore facility in VPOP3 version 5 or later.
Line 7: Line 8:
 Note that you do not need to stop VPOP3 to do this Note that you do not need to stop VPOP3 to do this
  
-  - First you need to find the appropriate database backup file. Usually VPOP3 makes daily database backups on a weekly cycle into the main VPOP3 installation directory, called **DBBACK-n.DMP**. You may have configured the settings to store these backups elsewhere or do them in a different cycle, but we will assume the defaults. Choose the appropriate backup file which will contain the messages you want to restore.+First you need to find the appropriate database backup file. Usually VPOP3 makes daily database backups on a weekly cycle into the main VPOP3 installation directory, called **DBBACK-n.DMP**. You may have configured the settings to store these backups elsewhere or do them in a different cycle, but we will assume the defaults. Choose the appropriate backup file which will contain the messages you want to restore.
  
-  - Now, you need to restore this database file into a temporary PostgreSQL database. For the purposes of this article, we will assume you will be restoring to the same database server as your main VPOP3 database, but to a database called **vpop3temp**. You could restore to a different PostgreSQL server on a different PC if you wish, and know how, but that is outside the scope of this article.+Now, you need to restore this database file into a temporary PostgreSQL database. For the purposes of this article, we will assume you will be restoring to the same database server as your main VPOP3 database, but to a database called **vpop3temp**. You could restore to a different PostgreSQL server on a different PC if you wish, and know how, but that is outside the scope of this article.
  
 To restore the database, you would open a command prompt, then go to the VPOP3 installation folder. Then, go to the **pgsql\bin** subfolder To restore the database, you would open a command prompt, then go to the VPOP3 installation folder. Then, go to the **pgsql\bin** subfolder
Line 22: Line 23:
 e.g. ''pg_restore -U postgres -p 5433 -d vpop3temp -j 4 -v //DBBACK-n.TMP//'' (the default password is ''pgsqlpass'') e.g. ''pg_restore -U postgres -p 5433 -d vpop3temp -j 4 -v //DBBACK-n.TMP//'' (the default password is ''pgsqlpass'')
  
-  - Now, go to the VPOP3 settings, and go to **Settings -> Database -> Restore**+Now, go to the VPOP3 settings, and go to **Settings -> Database -> Restore**
  
   * In the **Server** put ''localhost''   * In the **Server** put ''localhost''
Line 35: Line 36:
  
 Press **Start Restore** to start the restore process - note that this may take a while if there are lots of messages to be restored. Press **Start Restore** to start the restore process - note that this may take a while if there are lots of messages to be restored.
 +
 +Once the messages have been restored, you may want to drop the temporary database to free up disk space. To do this, use the command:
 +
 +e.g. ''dropdb -U postgres -p 5433 vpop3temp'' (default password is ''pgsqlpass'')
 +
 +====Restoring from older versions of VPOP3====
 +You can use this procedure to restore from v3 or v4 of VPOP3, but any messages over 100kB will not be restored because they are not stored in the database in the older versions of VPOP3.
how_to/restore_folder_-_v5.1341827994.txt.gz · Last modified: 2018/11/14 10:44 (external edit)