PSCS Wiki

User Tools

Site Tools

Trace: • Management Scripting • Move the message store - alternative method • Database query to list ALL messages in the LAN forwarding queue • Spamfilter database comparators • SMTP Relay Protection in VPOP3 • How To Upgrade VPOP3 to version 5 or later • Encryption
how_to:handling_database_backups

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
Last revisionBoth sides next revision
how_to:handling_database_backups [2013/09/20 09:01] – [Storing backups across the network] paulhow_to:handling_database_backups [2017/03/24 12:50] – paul
Line 1: Line 1:
-======Handling Database Backups====== +[[https://helpdesk.pscs.co.uk/957568-Backups]]
-In VPOP3 versions 3 and later, VPOP3 uses an external Database ([[http://www.postgresql.org|PostgreSQL]]) for storing data, such as message data, logging, configuration details etc. Because of the importance of this information, it is strongly recommended that this data is backed up regularly. +
- +
-By default, every day VPOP3 will backup the database to the VPOP3 installation directory as a file called 'DBBACK-x.DMP', where 'x' is the day number (0=Sunday, 1=Monday, etc). This means that the backups cycle on a weekly basis, so they don't grow indefinitely, and you always have a few backups even in case the latest one fails. +
- +
-=====Storing Database backups elsewhere===== +
-If you want VPOP3 to store the database backups somewhere else, for instance, to stop filling up the installation drive, you can change this simply. Go to the VPOP3 settings, then **Settings -> Database -> Backups**. +
- +
-The ''Dump Command Target File'' option tells VPOP3 where to store the backups, and what to call them. The default is ''DBBack-%w.dmp'' which tells it to store them in the VPOP3 directory, with the specified filename with the '%w' replaced by the week-day number. +
- +
-If you want VPOP3 to store the backups with the same name, but in the ''d:\vpop3backups'' folder, you could set the ''Dump Command Target File'' to  +
-''d:\vpop3backups\DBBack-%w.dmp'' +
- +
-If you want the backups stored on a monthly rotation, you could use ''d:\vpop3backups\dbback-%d.dmp'', etc +
- +
-====Storing backups on a USB drive==== +
-You can easily specify an external (eg USB) hard drive using the above method, simply specify the USB hard drive location as the target file. +
- +
-====Storing backups across the network==== +
-If you want VPOP3 to store the backups across the network (eg on a NAS device), it is a bit more complicated. +
- +
-Because VPOP3 is running as a service, it does not have access to mapped drives, so you cannot map the NAS to drive ''Z:'', and tell VPOP3 to store the backups as ''z:\dbback-%w.dmp''. +
- +
-Instead of using mapped drives, you have to use [[wp>Uniform_Naming_Convention#Uniform_Naming_Convention|UNC]] paths, eg ''\\server\share\path'' +
- +
-Also, because VPOP3 is running as a service, it needs to have permission to access the shared folder. In VPOP3 v6.1 and later you can specify the account details in the Database -> Backup settings. In earlier versions of VPOP3 you can set VPOP3 to run as a different account which has share permissions (check ALL file permissions in that case), or you could set the sharing permissions to allow the whole VPOP3 computer access to the shares. +
- +
how_to/handling_database_backups.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