issue2550678: Allow pagesize=-1 which returns all results.

[roundup.git] / doc / postgresql.txt

diff --git a/doc/postgresql.txt b/doc/postgresql.txt
index 60ac1365e3a7a4fec746044370a9f66b607c39bf..8fd6abc5626014866a7b5f58664229ce5043b763 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
 =============
@@ -12,37 +11,27 @@ Prerequisites
 To use PostgreSQL as backend for storing roundup data, you should
 additionally install:
 
-    1. PostgreSQL 7.x - http://www.postgresql.org/
+1. PostgreSQL 7.x - http://www.postgresql.org/
 
-    2. The psycopg python interface to PostgreSQL -
-       http://initd.org/software/initd/psycopg
+2. The psycopg python interface to PostgreSQL:
 
+     http://initd.org/software/initd/psycopg
 
-Additional configuration
-========================
+   It is recommended that you use at least version 1.1.21
 
-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_DBHOST = 'localhost'
-    POSTGRESQL_DBUSER = 'roundup'
-    POSTGRESQL_DBPASSWORD = 'roundup'
-    POSTGRESQL_DBNAME = 'roundup'
-    POSTGRESQL_PORT = 5432
-    POSTGRESQL_DATABASE = {'host':MYSQL_DBHOST, 'port':POSTGRESQL_PORT,
-                        'user':MYSQL_DBUSER, 'password':MYSQL_DBPASSWORD,
-           'database':MYSQL_DBNAME}
+Running the PostgreSQL unit tests
+=================================
 
-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
-POSTGRESQL_DBUSER must have rights to create a new database and to connect to
-the "template1" database, used while initializing roundup.
+The user that you're running the tests as will need to be able to access
+the postgresql database on the local machine and create and drop
+databases. See the config values in 'test/db_test_base.py' 
+about which database connection, name and user will be used.
 
 
-    Have fun with psycopg,
-    Federico Di Gregorio <fog@initd.org>
+Credit
+======
 
+The postgresql backend was originally submitted by Federico Di Gregorio
+<fog@initd.org>
 
-vim: et tw=80