Mercurial > p > roundup > code
comparison doc/postgresql.txt @ 2595:7b2ea468381a maint-0.7
merge from HEAD
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Tue, 20 Jul 2004 04:47:45 +0000 |
| parents | f255363e6d97 |
| children | 653c7ffce402 |
comparison
equal
deleted
inserted
replaced
| 2593:9e1c4c932323 | 2595:7b2ea468381a |
|---|---|
| 31 | 31 |
| 32 Additional configuration | 32 Additional configuration |
| 33 ======================== | 33 ======================== |
| 34 | 34 |
| 35 To initialise and use PostgreSQL database roundup's configuration file | 35 To initialise and use PostgreSQL database roundup's configuration file |
| 36 (config.py in the tracker's home directory) should be appended with the | 36 (``config.py`` in the tracker's home directory) should be ammended with |
| 37 following constants (substituting real values, obviously):: | 37 the following constants (substituting real values, obviously):: |
| 38 | 38 |
| 39 POSTGRESQL_DATABASE = {'database': 'rounduptest'} | 39 POSTGRESQL_DATABASE = {'database': 'rounduptest'} |
| 40 | 40 |
| 41 if not local, or a different user is to be used, then more information may | 41 Note that it's usually a good idea to explicitly specify the user which is |
| 42 be supplied:: | 42 to be used access the database too, to avoid permissions problems. If |
| 43 postgresql is not local, or a different user is to be used, then more | |
| 44 information may be supplied:: | |
| 43 | 45 |
| 44 POSTGRESQL_DATABASE = { | 46 POSTGRESQL_DATABASE = { |
| 45 'host': 'localhost', 'port': 5432, | 47 'host': 'localhost', 'port': 5432, |
| 46 'database': 'roundup' | 48 'database': 'roundup' |
| 47 'user': 'roundup', 'password': 'roundup', | 49 'user': 'roundup', 'password': 'roundup', |
| 48 } | 50 } |
| 49 | 51 |
| 50 Also note that you can leave some values out of | 52 Also note that you can leave some values out of |
| 51 ``POSTGRESQL_DATABASE``: 'host' and 'port' are not necessary when | 53 ``POSTGRESQL_DATABASE``: 'host' and 'port' are not necessary when |
| 52 connecting to a local database and 'password' | 54 connecting to a local database and 'password' |
| 53 is optional if postgres trusts local connections. The user specified in | 55 is optional if postgres trusts local connections. |
| 54 ``user`` must have rights to create a new database and to | |
| 55 connect to the "template1" database, used while initializing roundup. | |
| 56 | 56 |
| 57 Have fun with psycopg, | 57 The user specified in ``user`` must have rights to create a new database |
| 58 Federico Di Gregorio <fog@initd.org> | 58 and to connect to the "template1" database, used while initializing roundup. |
| 59 | 59 |
| 60 | |
| 61 | |
| 62 Credit | |
| 63 ====== | |
| 64 | |
| 65 The postgresql backend was originally submitted by Federico Di Gregorio | |
| 66 <fog@initd.org> | |
| 67 |