diff doc/postgresql.txt @ 1906:f255363e6d97

PostgreSQL backend lands. - that's the postgresql backend in (cleaned up doc, unit testing harness and the backend module itself) - also cleaned up the index maintenance code (actual checks for existence rather than bare-except failure mode)
author Richard Jones <richard@users.sourceforge.net>
date Tue, 11 Nov 2003 11:19:18 +0000
parents 3ffb7b56172a
children c0d6d5004464
line wrap: on
line diff
--- a/doc/postgresql.txt	Tue Nov 11 00:35:14 2003 +0000
+++ b/doc/postgresql.txt	Tue Nov 11 11:19:18 2003 +0000
@@ -18,6 +18,17 @@
    http://initd.org/software/initd/psycopg
 
 
+Running the PostgreSQL unit tests
+=================================
+
+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. Edit the ``test/test_postgresql.py`` database connection info if
+you wish to test against a different database.
+
+The test database will be called "rounduptest".
+
+
 Additional configuration
 ========================
 
@@ -25,22 +36,22 @@
 (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 = {'database': 'rounduptest'}
+
+if not local, or a different user is to be used, then more information may
+be supplied::
+
     POSTGRESQL_DATABASE = {
-        'host': MYSQL_DBHOST, 'port': POSTGRESQL_PORT,
-        'user': MYSQL_DBUSER, 'password': MYSQL_DBPASSWORD,
-        'database': MYSQL_DBNAME
+        '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
-``POSTGRESQL_DBUSER`` must have rights to create a new database and to
+``user`` must have rights to create a new database and to
 connect to the "template1" database, used while initializing roundup.
 
     Have fun with psycopg,

Roundup Issue Tracker: http://roundup-tracker.org/