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

Both sides previous revisionPrevious revision
Next revision
Previous revision
how_to:restore_folder_-_v5 [2012/07/09 10:06] paulhow_to:restore_folder_-_v5 [2018/11/14 10:45] (current) – external edit 127.0.0.1
Line 8: 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 23: 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 37: Line 37:
 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:+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'') 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.1341828361.txt.gz · Last modified: 2018/11/14 10:44 (external edit)