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 revisionBoth sides next revision
how_to:restore_folder_-_v5 [2012/07/09 11:06] paulhow_to:restore_folder_-_v5 [2012/07/09 11:06] paul
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'')
how_to/restore_folder_-_v5.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1