Mercurial > p > roundup > code
comparison doc/postgresql.txt @ 1873:f63aa57386b0
Backend improvements.
- using Zope3's test runner now, allowing GC checks, nicer controls and
coverage analysis
- all RDMBS backends now have indexes on several columns
- added testing of schema mutation, fixed rdbms backends handling of a
couple of cases
- !BETA! added postgresql backend, needs work !BETA!
| author | Richard Jones <richard@users.sourceforge.net> |
|---|---|
| date | Sat, 25 Oct 2003 22:53:26 +0000 |
| parents | |
| children | 3ffb7b56172a |
comparison
equal
deleted
inserted
replaced
| 1872:c085b4f4f0c0 | 1873:f63aa57386b0 |
|---|---|
| 1 ========================== | |
| 2 PostgreSQL/psycopg Backend | |
| 3 ========================== | |
| 4 | |
| 5 This is notes about PostreSQL backend based on the psycopg adapter for | |
| 6 roundup issue tracker. | |
| 7 | |
| 8 | |
| 9 Prerequisites | |
| 10 ============= | |
| 11 | |
| 12 To use PostgreSQL as backend for storing roundup data, you should | |
| 13 additionally install: | |
| 14 | |
| 15 1. PostgreSQL 7.x - http://www.postgresql.org/ | |
| 16 | |
| 17 2. The psycopg python interface to PostgreSQL - | |
| 18 http://initd.org/software/initd/psycopg | |
| 19 | |
| 20 | |
| 21 Additional configuration | |
| 22 ======================== | |
| 23 | |
| 24 To initialise and use PostgreSQL database roundup's configuration file | |
| 25 (config.py in the tracker's home directory) should be appended with the | |
| 26 following constants (substituting real values, obviously): | |
| 27 | |
| 28 POSTGRESQL_DBHOST = 'localhost' | |
| 29 POSTGRESQL_DBUSER = 'roundup' | |
| 30 POSTGRESQL_DBPASSWORD = 'roundup' | |
| 31 POSTGRESQL_DBNAME = 'roundup' | |
| 32 POSTGRESQL_PORT = 5432 | |
| 33 POSTGRESQL_DATABASE = {'host':MYSQL_DBHOST, 'port':POSTGRESQL_PORT, | |
| 34 'user':MYSQL_DBUSER, 'password':MYSQL_DBPASSWORD, | |
| 35 'database':MYSQL_DBNAME} | |
| 36 | |
| 37 Also note that you can leave some values out of POSTGRESQL_DATABASE: 'host' and | |
| 38 'port' are not necessary when connecting to a local database and 'password' | |
| 39 is optional if postgres trusts local connections. The user specified in | |
| 40 POSTGRESQL_DBUSER must have rights to create a new database and to connect to | |
| 41 the "template1" database, used while initializing roundup. | |
| 42 | |
| 43 | |
| 44 Have fun with psycopg, | |
| 45 Federico Di Gregorio <fog@initd.org> | |
| 46 | |
| 47 | |
| 48 vim: et tw=80 |