PSCS Wiki

User Tools

Site Tools

Trace:
reference:database_restore

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
reference:database_restore [2012/08/17 10:12] – paulreference:database_restore [2018/11/14 10:45] (current) – external edit 127.0.0.1
Line 1: Line 1:
 ======Database -> Restore Tab====== ======Database -> Restore Tab======
-This tab is only in VPOP3 Enterprise, and is for performing a partial (mailbox/mail folder) restore of the database. To do a full restore of the database, or for VPOP3 Basic/Standard, see the "[[how_to:restore_a_backup_of_vpop3|Restore a Backup of VPOP3]]" topic+This tab is only in VPOP3 Enterprise (v5 and later), and is for performing a partial (mailbox/mail folder) restore of the database. To do a full restore of the database, or for VPOP3 Basic/Standard, see the "[[how_to:restore_a_backup_of_vpop3|Restore a Backup of VPOP3]]" topic
  
 Using the **Restore** tab, you can recover one or more users' full mailboxes or individual messages from a backup. Note that you cannot filter by date, so if you just want to recover a few messages you should probably restore into a different mailbox/folder from the original location, and then move the desired messages across. Using the **Restore** tab, you can recover one or more users' full mailboxes or individual messages from a backup. Note that you cannot filter by date, so if you just want to recover a few messages you should probably restore into a different mailbox/folder from the original location, and then move the desired messages across.
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 46: Line 46:
 Go to a command prompt in the VPOP3\pgsql\bin folder and run a command like 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-dropdb.html|dropdb]] -U postgres -p 5433 vpop3temp+  dropdb -U postgres -p 5433 vpop3temp
 (password ''pgsqlpass'') (password ''pgsqlpass'')
  
reference/database_restore.1345194762.txt.gz · Last modified: 2018/11/14 10:44 (external edit)

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki