svn repository setup

[roundup.git] / doc / postgresql.txt

diff --git a/doc/postgresql.txt b/doc/postgresql.txt
index 4b634ba2980fa78daf617e8b81cbb9c688055dab..3cd32daba9842c4e1eb56b06c5f9a2a4618db72f 100644 (file)
--- a/doc/postgresql.txt
+++ b/doc/postgresql.txt
@@ -2,9 +2,8 @@
 PostgreSQL/psycopg Backend
 ==========================
 
-This is notes about PostreSQL backend based on the psycopg adapter for
-roundup issue tracker.
-
+This are notes about PostqreSQL backend based on the psycopg adapter for
+Roundup issue tracker.
 
 Prerequisites
 =============
@@ -15,7 +14,14 @@ additionally install:
 1. PostgreSQL 7.x - http://www.postgresql.org/
 
 2. The psycopg python interface to PostgreSQL:
-   http://initd.org/software/initd/psycopg
+
+     http://initd.org/software/initd/psycopg
+
+   It is recommended that you use at least version 1.1.21
+
+Some advice on setting up the postgresql backend may be found at:
+
+  http://www.magma.com.ni/wiki/index.cgi?TipsRoundupPostgres
 
 
 Running the PostgreSQL unit tests
@@ -29,31 +35,9 @@ you wish to test against a different database.
 The test database will be called "rounduptest".
 
 
-Additional configuration
-========================
-
-To initialise and use PostgreSQL database roundup's configuration file
-(config.py in the tracker's home directory) should be appended with the
-following constants (substituting real values, obviously)::
-
-    POSTGRESQL_DATABASE = {'database': 'rounduptest'}
-
-if not local, or a different user is to be used, then more information may
-be supplied::
-
-    POSTGRESQL_DATABASE = {
-        'host': 'localhost', 'port': 5432,
-        'database': 'roundup'
-        'user': 'roundup', 'password': 'roundup',
-    }
-
-Also note that you can leave some values out of
-``POSTGRESQL_DATABASE``: 'host' and 'port' are not necessary when
-connecting to a local database and 'password'
-is optional if postgres trusts local connections. The user specified in
-``user`` must have rights to create a new database and to
-connect to the "template1" database, used while initializing roundup.
+Credit
+======
 
-    Have fun with psycopg,
-    Federico Di Gregorio <fog@initd.org>
+The postgresql backend was originally submitted by Federico Di Gregorio
+<fog@initd.org>