This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
reference:database [2009/09/09 14:27] – paul | reference:database [2018/11/14 10:45] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ======Backups Tab====== | + | ======Settings -> Database====== |
- | The **Backups** tab lets you specify how VPOP3 will make its daily backup of its database. | + | |
- | In general the **PostgreSQL Binary Directory** and **Dump Command Options** settings should not be changed, but the **Dump Command Target File** setting can be changed to make VPOP3 store the backup in a different location, or with a different filename. | + | The **Settings -> Database** page lets you configure |
- | =====PostgreSQL Binary Directory===== | + | =====Tabs===== |
- | This is where the PostgreSQL executable files are stored - usually it is the **VPOP3\pgsql\bin** directory, but if you have a custom installation of PostgreSQL it may be in a different location. | + | |
- | =====Dump Command Options===== | + | * [[Database Backups|Backups]] |
- | VPOP3 uses the **pg_dump** command (part of the standard PostgreSQL distribution) to backup the database. | + | * [[Database Query|Query]] |
- | See [[http:// | + | |
+ | | ||
+ | | ||
- | The default options used by VPOP3 are simply **-F c** which tells pg_dump to make a compressed file. | ||
- | =====Dump Command Target File===== | ||
- | Specify the filename/ | ||
- | |||
- | You can implement a simple backup rotation system by using replaceable strings in the filename. For instance, the default name of **DBBACK-%w.DMP** tells VPOP3 to save the database as DBBACK-0.DMP on Sunday, DBBACK-1.DMP on Monday and so on. The following Sunday, the earlier DBBACK-0.DMP will be overwritten. | ||
- | |||
- | If you want VPOP3 to store the backup files on a network drive, you must use the **UNC** path format (**\\server\\share\\path**) not mapped drives, and you must be aware of network permissions for the Windows account which VPOP3 is running as. | ||
- | |||
- | |||
- | {{tag> |