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


Running the PostgreSQL unit tests
=================================

The user that you're running the tests as will need to be able to access
the postgresql database on the local machine and create and drop
databases. Edit the ``test/test_postgresql.py`` database connection info if
you wish to test against a different database.

The test database will be called "rounduptest".


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_DATABASE = {'database': 'rounduptest'}

if not local, or a different user is to be used, then more information may
be supplied::

    POSTGRESQL_DATABASE = {
        'host': 'localhost', 'port': 5432,
        'database': 'roundup'
        'user': 'roundup', 'password': 'roundup',
    }

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
``user`` 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>