==========================
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>