How to set up an DPM server with a postgres backend
===================================================

The DPM server is run by the dpmmgr user. This user requires a copy of
the host certificate files:

  cp -p /etc/grid-security/hostcert.pem /etc/grid-security/dpmmgr/dpmcert.pem
  cp -p /etc/grid-security/hostkey.pem /etc/grid-security/dpmmgr/dpmkey.pem
  chown dpmmgr:dpmmgr /etc/grid-security/dpmmgr/dpm*

Create a postgres database user for the DPM server:

  createuser -P <user>

The command above will prompt you for a password for the new user.

Create the DPM database:

  createdb -O <user> <dbname>

Create the DPM database tables:

  psql -W -U <user> <dbname> -f /usr/share/dpm/create_dpm_tables_postgres.sql

Let the DPM server know about the account information and make sure
only the dpmmgr user can read this information:

  touch /etc/DPMCONFIG
  chmod 600 /etc/DPMCONFIG
  chown dpmmgr:dpmmgr /etc/DPMCONFIG
  echo <user>/<password>@<dbserver>/<dbname> > /etc/DPMCONFIG

If the /<dbname> part is omitted the database "dpm_db" will be used.

If you have a firewall, open the DPM server port (5015).

Once the configuration is completed, start the DPM server:

  service dpm-postgres start

If you want to start the service automatically at boot time:

  chkconfig --add dpm-postgres