.. _postgresql:

PostgreSQL
##########

Test which version of PostgreSQL you have installed with:

:command:`psql -V`

You need PostgreSQL version 9.0 or higher.

If you install PostgreSQL manually rather than from a package, make sure the
server is started when the machine boots.

.. _posgresql-add-user:

Add a User and Create a DB
==========================

You need to add a new user to PostgreSQL for the Bugzilla
application to use when accessing the database. The following instructions
assume the defaults in :file:`localconfig`; if you
changed those, you need to modify the commands appropriately.

On most systems, to create a user in PostgreSQL, login as the root user, and
then switch to being the postgres (Unix) user:

:command:`su - postgres`

As the postgres user, you then need to create a new user:

:command:`createuser -U postgres -DRSP bugs`

When asked for a password, provide one and write it down for later reference.

The created user will not be a superuser (-S) and will not be able to create
new users (-R) or create databases (-D).

Next we will create a database for bugzilla to use

:command:`createdb -U postgres -O bugs bugs`

This will create a database named `bugs` that is owned (-O) by the `bugs` user.

.. _postgresql-access:

Permit Access
=============

Edit the file :file:`pg_hba.conf` which is
usually located in :file:`/var/lib/pgsql/data/`. In this file,
you will need to add a new line to it as follows:

::

    host   all    bugs   127.0.0.1    255.255.255.255  md5

This means that for TCP/IP (host) connections, allow connections from
'127.0.0.1' to 'all' databases on this server from the 'bugs' user, and use
password authentication ('md5') for that user.

Now, you will need to stop and start PostgreSQL fully. (Do not use any
'restart' command, due to the possibility of a change to
:file:`postgresql.conf`.)