Fulltext results:
- 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]
- 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
- 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
- Calendar.Events table
- =====Columns===== * id - this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]
- VPOP3.PostgresQuery
- ion 'VPOP3.PostgresQuery' performs a query on the PostgreSQL database and returns the results in a table It t
- 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]]
- LogDB.Messages table
- =Columns===== * msgid - this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]
- Spam Filter Rules: DBQueryOne
- * If you set the variable ${_dbquerytime} to a PostgreSQL INTERVAL value (eg "5 minutes") then the query wi
- Copy SMTP Rules - Database Query
- required operation, so we have to create a custom PostgreSQL function to copy the data. At a command prompt i
- Spamfilter.Whitelist table
- mary key. It is indexed case sensitively (because PostgreSQL does not support calculated primary key indices),
- 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
- 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
- LogDB.Attachments table
- lumns===== * attachid - this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]
- 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