(new related group 1)

Microsoft SQL Server

Voriges Thema

Nächstes Thema

PostgreSQL

IGEL UMS uses PostgreSQL functions (from Version 8.2). Older versions are not supported.

When installing a new instance of the PostgreSQL database, set the following parameters:

  1. Install the database cluster with UTF-8 coding.
  2. Accept the conditions for all addresses, not just localhost.
  3. Activate Procedural Language PL/pgsql in the default database.

For further information regarding installation of the PostgreSQL database, see http://www.postgresql.org.

Once installation is complete, carry out the following configuration procedure:

  1. Change the server parameters: The parameter listen_addresses in the file postgresql.conf must contain the host name of the IGEL UMS Server or '*' in order to allow connections to each host.
  2. Set up a host parameter in the file pg_hba.conf in order to give the UMS Server the authorization to log in using the user data defined there.

    If the IGEL UMS Server is installed on the same machine as the PostgreSQL Server, no changes to these files are needed.

  3. Launch the administration tool pgAdmin.
  4. Create a new login role with the name rmlogin.
  5. Create a new database with

    name = rmdb

    owner = rmlogin

    encoding = UTF-8

  6. Set up a new schema within the rmdb database with

    name = rmlogin

  7. Check whether the language plpgsql is available in the rmdb database.

    If not, set it up.

In the UMS Administrator, create a new PostgreSQL-type data source with the host name of the PostgreSQL Server and the correct server port (default is 5432), user rmlogin and database rmdb.