To backup VPOP3 version 5 you should:

• Backup the VPOP3 directory and subdirectories, except the VPOP3\pgsql directory tree. Make sure you backup the DBBack-<number>.DMP files, these contain the mailbox contents and other settings/data.

The DBBack-<number>.DMP files contain all the settings/data, so you can just backup those files now if you wish, although we'd recommend doing a full directory (except for the VPOP3\pgsql folder) backup if possible.

You do not need to backup the registry in version 5 (as you did for earlier versions) because settings are now stored in the main database.

If you want to make a Database backup at a specific time (rather than just the automated daily backups of the database) you can do the following:

1. Go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory.
2. Run pgsql\bin\pg_dump -p <port number> -F c -U vpop3 -f database.dmp vpop3 ('<port number>' is usually 5433)
3. At the password prompt, type vpop3pass (This assumes a standard installation, if your PostgreSQL installation is non-standard, then you may need to change this command appropriately)

This will create a file 'database.dmp' containing a backup of the database at the current state in the VPOP3 directory.

If you wish, you could create a task in Windows Task Scheduler to do this according to your own schedule.

If you are going to script the backup process, you need to automate the password. There is no command-line parameter to do this. You can either set the environment variable PGPASSWORD before running the pg_dump program, or create a pgpass.conf file.

VPOP3 version 5 uses PostgreSQL 9.1, and stores all settings/messages in the database. This means that you can use alternative PostgreSQL backup procedures. These are outside the scope of this article, but for advanced users may give big benefits, eg hot standby servers, point-in-time-recovery (PITR), incremental backups etc.

There are articles on the PostgreSQL website describing how to set these up, for instance:

• http://www.postgresql.org/docs/9.1/interactive/continuous-archiving.html
• http://www.postgresql.org/docs/9.1/interactive/high-availability.html
• http://raghavt.blogspot.co.uk/2011/05/postgresql-streaming-replication-on.html
• http://wiki.postgresql.org/wiki/Streaming_Replication

There will generally be a minute or less of downtime to do this, as, apart from the reconfiguration of the master PostgreSQL server, the rest of the process can be performed with the master PostgreSQL server running and operating normally.

See the PostgreSQL replication article for more details

(We can help set this up for you if you wish, but this will be chargeable - the current rate is £40 + VAT for a simple setup (ie replicating over a LAN with file sharing available between the two PCs). If you have a more complicated setup (eg replicating over the Internet) this can be more complex as it can involve configuring VPNs etc, so the cost may be greater)

To backup VPOP3 version 3 or 4 you should:

• Backup the VPOP3 directory and subdirectories, except the VPOP3\pgsql directory tree. Make sure you backup the DBBack-<number>.DMP files, these contain the mailbox contents.
• Backup the VPOP3 windows registry settings. These are at HKEY_LOCAL_MACHINE\SOFTWARE\PaulSmith\VPOP3. You can either export these manually from RegEdit, or run regedit /e vpop3.reg HKEY_Local_Machine\Software\PaulSmith\VPOP3 from a command prompt

If you want to make a Database backup at a specific time (rather than just the automated daily backups of the database) you can do the following:

1. Go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory.
2. Run pgsql\bin\pg_dump -F c -U vpop3 -f database.dmp vpop3
3. At the password prompt, type vpop3pass (This assumes a standard installation, if your PostgreSQL installation is non-standard, then you may need to change this command appropriately)

This will create a file 'database.dmp' containing a backup of the database at the current state in the VPOP3 directory.

To backup earlier versions of VPOP3 you should:

• Backup the VPOP3 directory and all subdirectories
• Backup the VPOP3 windows registry settings. These are at HKEY_LOCAL_MACHINE\SOFTWARE\PaulSmith\VPOP3. You can either export these manually from RegEdit, or run regedit /e vpop3.reg HKEY_Local_Machine\Software\PaulSmith\VPOP3 from a command prompt