PSCS Wiki

User Tools

Site Tools

Trace: • How To Move VPOP3 Version 2 to a New PC • Running database updates within a transaction • Using VPOP3 Advanced Features with LAN Forwarding • How to create an SSL Certificate • What is Software Maintenance? • Setting up VPOP3 to work with Exchange 2003 • "Too many logins" error message • Autoupdate process failed with error code 786432 • What is PostgreSQL? • Database Issues
reference:database_restore

Differences

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

Link to this comparison view

Next revision		Previous revision
Next revisionBoth sides next revision
reference:database_restore [2012/08/17 10:09] – created paulreference:database_restore [2013/02/08 08:49] – [Cleaning Up] paul
Line 11: Line 11:
 To restore a backup to a temporary database on the VPOP3 computer, go to a command prompt in the VPOP3\pgsql\bin folder and run a command like To restore a backup to a temporary database on the VPOP3 computer, go to a command prompt in the VPOP3\pgsql\bin folder and run a command like
  
-  [[http://www.postgresql.org/docs/9.1/static/app-createdb.html|createdb]] -U postgres -E SQL_ASCII -p 5433 -T template0 vpop3temp+  createdb -U postgres -E SQL_ASCII -p 5433 -T template0 vpop3temp
 (password ''pgsqlpass'') (password ''pgsqlpass'')
  
Line 17: Line 17:
  
 Then, run a command like: Then, run a command like:
-  [[http://www.postgresql.org/docs/9.1/static/app-pgrestore.html|pg_restore]] -U postgres -p 5433 -d vpop3temp -j 4 -v dbback.dmp+  pg_restore -U postgres -p 5433 -d vpop3temp -j 4 -v dbback.dmp
 (password ''pgsqlpass'') (password ''pgsqlpass'')
  
Line 40: Line 40:
  
 When you press **Start Restore** the restore process starts. It may take some time depending on how many messages need to be restored. You can continue using VPOP3 or edit more settings while the restore process is running. When you press **Start Restore** the restore process starts. It may take some time depending on how many messages need to be restored. You can continue using VPOP3 or edit more settings while the restore process is running.
 +
 +=====Cleaning Up=====
 +Once the messages have been restored you can remove the temporary database
 +
 +Go to a command prompt in the VPOP3\pgsql\bin folder and run a command like
 +
 +  dropdb -U postgres -p 5433 vpop3temp
 +(password ''pgsqlpass'')
  
 ====Notes==== ====Notes====
   * If a restored message already exists in the message store, it will be duplicated, so you will get the original copy PLUS the restored copy   * If a restored message already exists in the message store, it will be duplicated, so you will get the original copy PLUS the restored copy
   * If a message is to be restored to a folder which no longer exists, VPOP3 will create the folder for you   * If a message is to be restored to a folder which no longer exists, VPOP3 will create the folder for you
- +  * The restored messages will be stored in a folder according to the following table:
-  * The restored messages will be stored in a folder according to the following table+
  
 ^ Selected Target User ^ Selected Target Folder ^ Number Of Users Being Restored ^ Destination User ^ Destination Folder ^ ^ Selected Target User ^ Selected Target Folder ^ Number Of Users Being Restored ^ Destination User ^ Destination Folder ^
Line 54: Line 61:
 | X | Y | 1 | X | Y/<original folder> |  | X | Y | 1 | X | Y/<original folder> | 
 | X | Y | >1 | X | Y/<original user>/<original folder> | | X | Y | >1 | X | Y/<original user>/<original folder> |
- 
reference/database_restore.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki