Mercurial > p > roundup > code
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,
