Database backups

In VPOP3 versions 3 and later, VPOP3 uses an external Database (PostgreSQL (http://www.postgresql.org/)) 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 ...

Changing the database backup file names

To change the automatic database backup filename, go to the VPOP3 settings, then Settings → Database → Backups (http://www.pscs.co.uk/manual/database_backups.html). The Dump Command Target File option tells VPOP3 where to store the backups, and what to call them. The default is DBBack-%w.dmp. You could change this to “DatabaseBackup.dmp” or whatever you prefer. In the default filename, then %w is replaced by the weekday-number (0=Sunday, 1=Monday, etc)

Changing the backup rotation cycle

The default automatic database backup which VPOP3 performs cycles backup files on a weekly basis. This is performed by saving the backup as a file DBBack-0.dmp on Sunday, DBBack-1.dmp on Monday, etc. The following Sunday, the previous DBBack-0.dmp file is overwritten meaning you have a week's worth of backups available. This rotation is achieved by using 'replacements' in the backup filename. In the default case, the replacement %w tells VPOP3 to replace that text with the day of week number (0...

Setting where database backups are stored

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 (http://www.pscs.co.uk/manual/database_backups.html). The Backup 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 ...