Differences

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

--- reference:database_schema_used_in_vpop3_5.x [2012/05/17 11:48] – paul
+++ reference:database_schema_used_in_vpop3_5.x [2015/09/23 13:46] – external edit 127.0.0.1
@@ Line 9: / Line 9: @@
 The default database name used by VPOP3 is 'vpop3', the default username is 'vpop3', and the default password is 'vpop3pass'. In VPOP3 version 5, the connection port number is usually port 5433. In VPOP3 versions 3 and 4 the connection port number is usually port 5432.
-VPOP3 uses various PostgreSQL '[[http://www.postgresql.org/docs/9.0/static/ddl-schemas.html|schemas]]' to separate out different sorts of data. This section is ordered by the PostgreSQL schema names
+In VPOP3 version 5, the database connection information is stored in the **VPOP3.INI** file in the VPOP3 installation directory.
+To access the database, we generally use [[http://www.postgresql.org/docs/9.1/static/app-psql.html|PSQL]], but there are other tools available if you prefer them, such as [[http://www.pgadmin.org/|PgAdmin]]. [[http://psqlodbc.projects.postgresql.org/|ODBC drivers]] are also available for PostgreSQL if you have ODBC client software you like using. We don't support or recommend any of these - contact the publishers of that software directly for help.
+VPOP3 uses various PostgreSQL '[[http://www.postgresql.org/docs/9.1/static/ddl-schemas.html|schemas]]' to separate out different sorts of data. This section is ordered by the PostgreSQL schema names
   * [[addresses]]
@@ Line 27: / Line 31: @@
   * [[sms]]
   * [[smtpstats]]
-  * [[spamfilter]]
+  * [[db spamfilter|spamfilter]]
   * [[db users|users]]

PSCS Wiki

User Tools

Site Tools

Differences

Page Tools