Backup just VPOP3 settings

We recommend that you do a full VPOP3 backup regularly. By default VPOP3 automatically backs the database up every day. We recommend using this backup when recovering VPOP3 or moving VPOP3.

If, for some reason, you wish to just backup just the VPOP3 settings, then there is no easy way to just do that, because there are many different types of settings, and some people may think that some things (eg blocked IP addresses) are settings whereas other people may think that those aren't settings.

A good compromise is to backup everything that isn't message data or log data. To do this, at a command prompt, go to the VPOP3 directory and run

pgsql\bin\pg_dump -v -U vpop3 -p 5433 -F c -f database.dmp -N messages -N outqueue -N logdb -N archive vpop3

(password is 'vpop3pass')

This will backup all the settings (and some data, but not bulk data) to a file called 'database.dmp'.

If you want to keep historical logging data, omit the -N logdb

If you want to keep the message archive indices, omit the -N archive

(for more details on the pg_dump program, see https://www.postgresql.org/docs/9.5/app-pgdump.html )

 

To restore this data, just restore it as normal (to a blank database). VPOP3 will create the missing database tables the first time that it is run. It is not possible to easily restore the settings backup into an existing database.

(This article is for VPOP3 v5 or later)