Note: this section is not really complete ... you may also want to check out the unofficial guides for more information on details.

Small Howto

Go to the OpenGroupware.org installation directory (with .deb packages, this defaults to /usr/lib/opengroupware.org, for .rpm packages go to /opt/opengroupware.org).

Go to the 'Database' subdir, then change to the directory matching your database (PostgreSQL). There'll you find the schema files used for the database.

Create a new database and a new database user (using 'createdb' and 'createuser' as root) and insert this schema into the database. Now change to the 'opengroupware' user and use the 'Defaults' tool to write the database configuration.

Below you see a transcript of the database installation. Just follow these steps and everything should work well for you.

$ su - root
$ su - postgres
# cd /usr/lib/opengroupware.org/Database/PostgreSQL
# createdb OGo
# createuser -A -D OGo
# psql OGo OGo
Welcome to psql 7.3.3, the PostgreSQL interactive terminal.
Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help on internal slash commands
       \g or terminate with semicolon to execute query
       \q to quit
OGo=> \i pg-build-schema.psql
[output cut]
OGo=> \q

Now configure the connection information in OGo:

# su - opengroupware
$ source $HOME/OpenGroupware.org.sh
$ Defaults write NSGlobalDomain LSConnectionDictionary \
   '{databaseName = OGo; hostName = localhost; password = \
   ""; port = 5432; userName = OGo}' # on one line
$ Defaults read NSGlobalDomain LSConnectionDictionary
{
    databaseName = OGo;
    hostName = localhost;
    password = "";
    port = 5432;
    userName = OGo;
}
$ Defaults write NSGlobalDomain LSAdaptor PostgreSQL72

Configuring PostgreSQL

It is important that you can connect PostgreSQL using TCP/IP because that is the only mechanism supported by the OGo database adaptor in the moment. So if you run into "cannot connect database" issues, you are probably missing some PostgreSQL configuration.

To check whether TCP/IP properly works for your installation use that:

$ psql -h localhost OGo OGo

The -h localhost will trigger an TCP/IP connect. If the above does not work for you, you may need to fix ~postgres/data/postgresql.conf and enable the tcpip_socket option and you may need to setup authentication in ~postgres/data/pg_hba.conf.
Note that ident authentication does not work with TCP/IP!