==========================
PostgreSQL/psycopg Backend
==========================

This is notes about PostreSQL backend based on the psycopg adapter for
roundup issue tracker.


Prerequisites
=============

To use PostgreSQL as backend for storing roundup data, you should
additionally install:

    1. PostgreSQL 7.x - http://www.postgresql.org/

    2. The psycopg python interface to PostgreSQL -
       http://initd.org/software/initd/psycopg


Additional configuration
========================

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):

    POSTGRESQL_DBHOST = 'localhost'
    POSTGRESQL_DBUSER = 'roundup'
    POSTGRESQL_DBPASSWORD = 'roundup'
    POSTGRESQL_DBNAME = 'roundup'
    POSTGRESQL_PORT = 5432
    POSTGRESQL_DATABASE = {'host':MYSQL_DBHOST, 'port':POSTGRESQL_PORT,
                        'user':MYSQL_DBUSER, 'password':MYSQL_DBPASSWORD,
           'database':MYSQL_DBNAME}

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 connect to
the "template1" database, used while initializing roundup.


    Have fun with psycopg,
    Federico Di Gregorio <fog@initd.org>


vim: et tw=80