Differences

This shows you the differences between two versions of the page.

--- 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 the use of the back-end database which VPOP3 uses for configuration data, message storage and other uses.
-=====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://www.postgresql.org/docs/8.3/static/app-pgdump.html]] for details on the **pg_dump** command, and the command line options it supports.
+  * [[Database Connection|Connection]]
+  * [[Database Message Store|Message Store]]
+  * [[Database Restore|Restore]]
-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/location here. For instance if you specify **c:\backups\dbback.dmp** then VPOP3 will write every database backup to the file **dbback.dmp** in the **c:\backups** folder on the server.
-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>backup database}}

PSCS Wiki

User Tools

Site Tools

Differences

Page Tools