PSCS Wiki

User Tools

Site Tools

Trace: • POP3 Protocol
reference:database

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
Next revisionBoth sides next revision
reference:database [2009/09/09 14:27] – paulreference:database [2011/08/02 15:18] – [Backups Tab] paul
Line 1: Line 1:
-======Backups Tab======+======Settings -> Database====== 
 +=====Backups Tab=====
 The **Backups** tab lets you specify how VPOP3 will make its daily backup of its database. The **Backups** tab lets you specify how VPOP3 will make its daily backup of its database.
 +
 +To restore a backup of the database, see [[how_to:restore_a_backup_of_vpop3]]
  
 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. 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.
  
-=====PostgreSQL Binary Directory=====+====PostgreSQL Binary Directory====
 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. 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=====+====Dump Command Options====
 VPOP3 uses the **pg_dump** command (part of the standard PostgreSQL distribution) to backup the database.  VPOP3 uses the **pg_dump** command (part of the standard PostgreSQL distribution) to backup the database. 
 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. 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.
Line 13: Line 16:
 The default options used by VPOP3 are simply **-F c** which tells pg_dump to make a compressed file. The default options used by VPOP3 are simply **-F c** which tells pg_dump to make a compressed file.
  
-=====Dump Command Target 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. 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.
  
reference/database.txt · Last modified: 2018/11/14 10:45 by 127.0.0.1

Page Tools

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki