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/10/08 09:48] – [VPOP3 version 5] paul | how_to:backup_vpop3 [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 19: | 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 41: | 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 61: | 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.1381222138.txt.gz · Last modified: 2018/11/14 10:44 (external edit)
Page Tools
