Fulltext results:
- Database schema used in VPOP3 5.x
- well. Also note that VPOP3 5.x uses [[http://www.postgresql.org/docs/9.1/static/release-9-1-3.html|PostgreSQL 9.1]] or later, whereas 3.x-4.x use PostgreSQL [[http://www.postgresql.org/docs/8.3/static/release-8-3-15.html|8.3]] or later. The default database name us
- Database -> Backups Tab
- the VPOP3 backup feature, or manually backup the PostgreSQL database using the pg_dump command, or use another program to backup the PostgreSQL database if you wish. Note that a simple disk cop... _to:restore_a_backup_of_vpop3]] In general the **PostgreSQL Binary Directory** and **Dump Command Options** s... rent location, or with a different filename. ====PostgreSQL Binary Directory==== This is where the PostgreSQL
- Users.AutoresponderConditions table
- this begins with **/** then it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCT... by '/' characters, otherwise it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCT... this begins with **/** then it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCT... by '/' characters, otherwise it is a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCT
- Spamfilter database comparators
- nsensitive (eg **nei**) * ~ does a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCT... ion]] match comparison * !~ does a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCT... ] not-match comparison * ~* does a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCT... on]] match comparison * !~* does a [[http://www.postgresql.org/docs/9.1/static/functions-matching.html#FUNCT
- Database -> Restore Tab
- elf, but you may restore it to an installation of PostgreSQL 9.1 or later on another PC if necessary, for inst... ''PQconnectdbParams'' section of the [[http://www.postgresql.org/docs/9.1/static/libpq-connect.html|libpq conn
- Spam Filter Rules: DBDeleteTime
- ike "5 seconds" or "10 minutes" or "3 weeks" (see PostgreSQL Interval Input - [[http://www.postgresql.org/docs/9.1/static/datatype-datetime.html#DATATYPE-INTERVAL-INPUT]]
- Calendar.Calendars table
- ==Columns===== * calid - this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|integer
- Running database updates within a transaction
- Now, you can check the results of the query. The PostgreSQL **psql** program will display the number of rows
- Spam Filter Rules: DBQueryOne
- * If you set the variable ${_dbquerytime} to a PostgreSQL INTERVAL value (eg "5 minutes") then the query wi
- Spamfilter.Whitelist table
- mary key. It is indexed case sensitively (because PostgreSQL does not support calculated primary key indices),
- LogDB.Recipients table
- Columns===== * rcptid - this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]
- LogDB.SpamRules table
- mns===== * spamruleid - this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]
- LogDB.Sessions table
- =Columns===== * sessid - this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]
- Calendar.Events table
- =====Columns===== * id - this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]
- LogDB.Messages table
- =Columns===== * msgid - this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]
