This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
reference:database_message_store [2012/08/17 10:01] – created paul | reference:database_message_store [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ======Database -> Restore | + | ======Database -> Message Store Tab====== |
- | This tab is only in VPOP3 Enterprise, and is for performing a partial (mailbox/ | + | This tab says how VPOP3 handles its message store |
- | Using the **Restore** tab, you can recover one or more users' full mailboxes or individual | + | =====Message Store===== |
+ | The **Delay while moving messages** setting tells VPOP3 how quickly to import | ||
- | Also, you can use the **[[user_advanced|Message Recycle Bin]]** facility to recover messages which have been deleted within | + | Note that VPOP3 can read messages from either |
- | 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 ' | ||
- | =====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 ' |
- | 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:// | + | 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, |
- | (password '' | + | |
- | This will create a database called ' | + | 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 |
- | [[http:// | + | |
- | (password '' | + | |
- | + | ||
- | This will restore | + | |
- | + | ||
- | =====Restoring message data from the temporary database===== | + | |
- | Then, in the VPOP3 settings, enter the connection details into the **Restore** tab. | + | |
- | + | ||
- | Eg | + | |
- | + | ||
- | * Server: '' | + | |
- | * Username: '' | + | |
- | * Password: '' | + | |
- | * Port: '' | + | |
- | * Database: '' | + | |
- | + | ||
- | (If you need to enter customised parameters, you can edit the Connection String value directly (see the '' | + | |
- | + | ||
- | Choose the appropriate users/ | + | |
- | + | ||
- | Finally, you choose what to do with the restored messages. You can select the target user where the restored messages will go (or ' | + | |
- | + | ||
- | 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 | + | |
- | + | ||
- | * The restored messages will be stored in a folder according to the following table | + | |
- | + | ||
- | ^ Selected ^ Selected ^ Number Of Users ^ ^ | + | |
- | ^ Target User ^ Target Folder ^ Being Restored ^ Destination User ^ Destination Folder ^ | + | |
- | | Original | < | + | |
- | | Original | Y | any | < | + | |
- | | X | < | + | |
- | | X | < | + | |
- | | X | Y | 1 | X | Y/< | + | |
- | | X | Y | >1 | X | Y/< | + | |
+ | 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: |