Mercurial > p > roundup > code

comparison doc/postgresql.txt @ 1875:3ffb7b56172a

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
*** empty log message ***
author Richard Jones <richard@users.sourceforge.net>
date Sat, 25 Oct 2003 23:00:42 +0000
parents f63aa57386b0
children f255363e6d97
comparison
equal deleted inserted replaced
1874:f0a327a6ac8b 1875:3ffb7b56172a
10 ============= 10 =============
11 11
12 To use PostgreSQL as backend for storing roundup data, you should 12 To use PostgreSQL as backend for storing roundup data, you should
13 additionally install: 13 additionally install:
14 14
15 1. PostgreSQL 7.x - http://www.postgresql.org/ 15 1. PostgreSQL 7.x - http://www.postgresql.org/
16 16
17 2. The psycopg python interface to PostgreSQL - 17 2. The psycopg python interface to PostgreSQL:
18 http://initd.org/software/initd/psycopg 18 http://initd.org/software/initd/psycopg
19 19
20 20
21 Additional configuration 21 Additional configuration
22 ======================== 22 ========================
23 23
24 To initialise and use PostgreSQL database roundup's configuration file 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 25 (config.py in the tracker's home directory) should be appended with the
26 following constants (substituting real values, obviously): 26 following constants (substituting real values, obviously)::
27 27
28 POSTGRESQL_DBHOST = 'localhost' 28 POSTGRESQL_DBHOST = 'localhost'
29 POSTGRESQL_DBUSER = 'roundup' 29 POSTGRESQL_DBUSER = 'roundup'
30 POSTGRESQL_DBPASSWORD = 'roundup' 30 POSTGRESQL_DBPASSWORD = 'roundup'
31 POSTGRESQL_DBNAME = 'roundup' 31 POSTGRESQL_DBNAME = 'roundup'
32 POSTGRESQL_PORT = 5432 32 POSTGRESQL_PORT = 5432
33 POSTGRESQL_DATABASE = {'host':MYSQL_DBHOST, 'port':POSTGRESQL_PORT, 33 POSTGRESQL_DATABASE = {
34 'user':MYSQL_DBUSER, 'password':MYSQL_DBPASSWORD, 34 'host': MYSQL_DBHOST, 'port': POSTGRESQL_PORT,
35 'database':MYSQL_DBNAME} 35 'user': MYSQL_DBUSER, 'password': MYSQL_DBPASSWORD,
36 'database': MYSQL_DBNAME
37 }
36 38
37 Also note that you can leave some values out of POSTGRESQL_DATABASE: 'host' and 39 Also note that you can leave some values out of
38 'port' are not necessary when connecting to a local database and 'password' 40 ``POSTGRESQL_DATABASE``: 'host' and 'port' are not necessary when
41 connecting to a local database and 'password'
39 is optional if postgres trusts local connections. The user specified in 42 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 43 ``POSTGRESQL_DBUSER`` must have rights to create a new database and to
41 the "template1" database, used while initializing roundup. 44 connect to the "template1" database, used while initializing roundup.
42
43 45
44 Have fun with psycopg, 46 Have fun with psycopg,
45 Federico Di Gregorio <fog@initd.org> 47 Federico Di Gregorio <fog@initd.org>
46 48
47
48 vim: et tw=80
Roundup Issue Tracker: http://roundup-tracker.org/