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
- 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
- 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
- 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
- Calendar.Events table
- =====Columns===== * id - this is a [[http://www.postgresql.org/docs/9.0/static/datatype-numeric.html|bigint]
- 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
- Database -> Message Store Tab
- iately. As with most enterprise database systems, PostgreSQL does not free up emptied space in the database fi
- Group a user's folders into letter groups
- Then copy/paste this into the PSQL prompt: <code postgresql [enable_line_numbers="true"]> CREATE OR REPLACE F
- LogDB.Attachments table
- lumns===== * attachid - 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]
- LogDB.Recipients table
- Columns===== * rcptid - 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]
