how_to:backup_vpop3
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| how_to:backup_vpop3 [2013/09/20 09:11] – [Alternative Backup Procedures] paul | how_to:backup_vpop3 [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ======How to Backup VPOP3====== | ======How to Backup VPOP3====== | ||
| - | =====VPOP3 version 5===== | + | |
| - | To backup VPOP3 version 5 you should: | + | By default VPOP3 v3 and later will automatically perform a daily backup of the database into a file called DBBACK-x.DMP, |
| + | |||
| + | In VPOP3 v5 and later, this database backup is a full backup of VPOP3. In VPOP3 v3 & v4, it is a partial backup, so you need to backup other files/data as well. | ||
| + | |||
| + | See our " | ||
| + | =====VPOP3 version 5 and later===== | ||
| + | To backup VPOP3 version 5 and later you should: | ||
| * Backup the VPOP3 directory and subdirectories, | * Backup the VPOP3 directory and subdirectories, | ||
| Line 13: | Line 19: | ||
| - Go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory. | - Go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory. | ||
| - | - Run '' | + | - Run '' |
| - At the password prompt, type '' | - At the password prompt, type '' | ||
| This will create a file ' | This will create a file ' | ||
| + | ===Task Scheduler=== | ||
| If you wish, you could create a task in Windows Task Scheduler to do this according to your own schedule. | 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 [[http:// | 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 [[http:// | ||
| + | |||
| + | An example .CMD file is below - you may need to edit paths in this file before using it, and test it thoroughly in your situation before relying on it for your backups | ||
| + | |||
| + | < | ||
| + | SET VPOP3PATH=c: | ||
| + | SET BACKUPPATH=c: | ||
| + | |||
| + | SET PGDUMPPATH=%VPOP3PATH%\pgsql\bin\pg_dump.exe | ||
| + | SET PGPASSWORD=vpop3pass | ||
| + | " | ||
| + | if errorlevel 1 goto error | ||
| + | move " | ||
| + | goto end | ||
| + | :error | ||
| + | REM Can log/report errors here | ||
| + | :end | ||
| + | SET PGPASSWORD=</ | ||
| ====Alternative Backup Procedures==== | ====Alternative Backup Procedures==== | ||
| ===Replication/ | ===Replication/ | ||
| Line 35: | Line 59: | ||
| See the [[PostgreSQL replication]] article for more details | 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) | + | (We can help set this up for you if you wish, but this will be chargeable - the current rate is £100 + 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) |
| ===Backing up the PostgreSQL database directly=== | ===Backing up the PostgreSQL database directly=== | ||
| Line 55: | Line 79: | ||
| - Go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory. | - Go to a command prompt on the VPOP3 computer, and go to the VPOP3 directory. | ||
| - | - Run '' | + | - Run '' |
| - At the password prompt, type '' | - At the password prompt, type '' | ||
how_to/backup_vpop3.1379664704.txt.gz · Last modified: 2018/11/14 10:44 (external edit)
Page Tools
