Differences

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

--- how_to:handling_database_backups [2012/05/30 14:44] – [Handling Database Backups] paul
+++ how_to:handling_database_backups [2018/11/14 10:45] (current) – external edit 127.0.0.1
@@ 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, so you could 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.

PSCS Wiki

User Tools

Site Tools

Differences

Page Tools