Mercurial > p > roundup > code
diff doc/postgresql.txt @ 2594:c0d6d5004464
rdbms doc updates
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Tue, 20 Jul 2004 04:38:54 +0000 |
| parents | f255363e6d97 |
| children | 653c7ffce402 |
line wrap: on
line diff
--- a/doc/postgresql.txt Tue Jul 20 02:07:58 2004 +0000 +++ b/doc/postgresql.txt Tue Jul 20 04:38:54 2004 +0000 @@ -33,13 +33,15 @@ ======================== 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):: +(``config.py`` in the tracker's home directory) should be ammended 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:: +Note that it's usually a good idea to explicitly specify the user which is +to be used access the database too, to avoid permissions problems. If +postgresql is not local, or a different user is to be used, then more +information may be supplied:: POSTGRESQL_DATABASE = { 'host': 'localhost', 'port': 5432, @@ -50,10 +52,16 @@ 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. +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. + + - Have fun with psycopg, - Federico Di Gregorio <fog@initd.org> +Credit +====== +The postgresql backend was originally submitted by Federico Di Gregorio +<fog@initd.org> +
