Differences

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

--- reference:database_message_store [2012/08/17 10:04] – paul
+++ reference:database_message_store [2018/11/14 10:45] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-======Database -> Restore Tab======
+======Database -> Message Store 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 says how VPOP3 handles its message store
-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.
+=====Message Store=====
+The **Delay while moving messages** setting tells VPOP3 how quickly to import messages into the new database structure if it was upgraded from version 2.x or earlier. Usually this is OK to be left as it is, but if there is some special requirement to import the messages more quickly, you can decrease this number, but that will increase the load on the server.
-Also, you can use the **[[user_advanced|Message Recycle Bin]]** facility to recover messages which have been deleted within the last few days.
+Note that VPOP3 can read messages from either the old or new message stores, so it does not matter too much if some messages are still in the version 2 message store and other messages are in the new database store. However, during this time, the database backups will not contain all your data, so you should [[how to:backup_vpop3|backup the VPOP3 directories]] as well (except for the pgsql folder tree)
-To use this database restore facility, first you need to restore a database backup to a temporary database. This will usually be done on the VPOP3 computer itself, but you may restore it to an installation of PostgreSQL 9.1 or later on another PC if necessary, for instance if there is insufficient disk space on the VPOP3 computer.
+=====Message Recycle Bin=====
+If you have VPOP3 Enterprise, there is a 'Message Recycle Bin' which keeps deleted messages for a few days, in case they were deleted by mistake.
-=====Restoring a VPOP3 database backup to a temporary database=====
+The default is 72 hours, but you can increase or decrease this number if necessary. If you set it to '0' the recycle bin functionality is disabled.
-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
+You can also use the **Purge Recycle Bin** button to trigger a purge of the recycle bin data. Note that clearing the recycle bin will not occur immediately, especially if there is a lot of data there.
-(password ''pgsqlpass'')
-This will create a database called 'vpop3temp'
+The **Recycle Bin Size** section tells you how many messages are currently in the recycle bin.
-Then, run a command like:
+To recover messages using the recycle bin, go to the **[[user_advanced|Edit User -> Advanced tab]]** for the relevant user.
-  [[http://www.postgresql.org/docs/9.1/static/app-pgrestore.html|pg_restore]] -U postgres -p 5433 -d vpop3temp -j 4 -v dbback.dmp
-(password ''pgsqlpass'')
-This will restore the 'dbback.dmp' backup into the 'vpop3temp' database
-=====Restoring message data from the temporary database=====
-Then, in the VPOP3 settings, enter the connection details into the **Restore** tab.
-Eg
-  * Server: ''localhost''
-  * Username: ''postgres''
-  * Password: ''pgsqlpass''
-  * Port: ''5433''
-  * Database: ''vpop3temp''
-(If you need to enter customised parameters, you can edit the Connection String value directly (see the ''PQconnectdbParams'' section of the [[http://www.postgresql.org/docs/9.1/static/libpq-connect.html|libpq connect]] documentation for available options))
-Choose the appropriate users/folders from the grid underneath the connection parameters
-Finally, you choose what to do with the restored messages. You can select the target user where the restored messages will go (or 'Original User' for the messages to go to the original user), and the target folder for them to be restored to (or leave blank to go to the original folder). You can also specify whether restored messages should be marked as unread, and/or flagged (or 'starred', depending on how your email client displays the IMAP4 'flagged' message status).
-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.
-====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 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
-^ Selected Target User ^ Selected Target Folder ^ Number Of Users Being Restored ^ Destination User ^ Destination Folder ^
-| Original | <blank> | any | <original user> | <original folder> |
-| Original | Y | any | <original user> | Y/<original folder> |
-| X | <blank> | 1 | X | <original folder> |
-| X | <blank> | >1 | X | <original user>/<original folder> |
-| X | Y | 1 | X | Y/<original folder> |
-| X | Y | >1 | X | Y/<original user>/<original folder> |
+Note that because the message data is stored in the database, purging the recycle bin will not free up disk space immediately. As with most enterprise database systems, PostgreSQL does not free up emptied space in the database files. This is for performance reasons. To free disk space, see the [[how_to:database_maintenance#freeing_disk_space|Freeing disk space]] topic. Note that VPOP3 will need to be closed down while this is done.

PSCS Wiki

User Tools

Site Tools

Differences

Page Tools