PostgreSQL
For details on the supported database systems, see the "Supported Environment" section of the release notes. Details of the requirements when installing and operating the database can be found in the documentation for the particular DBMS.
Configuration Hints
The UMS Server runs several services in parallel to provide the functionality. These services establish connections to the database. The database must therefore allow a certain number of connections. The recommendation is to set the maximum number of connections and the shared buffer size to the following values:
max_connections = 128 * [number of UMS Servers]
shared_buffers = 128MB * [number of UMS Servers]
These values are set in the configuration file for the PostgreSQL database (see the PostgreSQL documentation).
When installing a new instance of the PostgreSQL database, set the following parameters:
Install the database cluster with
UTF-8
coding.Accept the conditions for all addresses, not just
localhost.
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:
Change the server parameters: The parameter
listen_addresses
in the filepostgresql.conf
must contain the host name of the IGEL UMS Server or'*'
in order to allow connections to each host.Set up a
host
parameter in the filepg_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.
Launch the administration tool pgAdmin.
Create a new login role with the name
rmlogin.
Create a new database with
name =rmdb
owner =rmlogin
encoding =UTF-8
Set up a new schema within the rmdb database with
name =rmlogin
Check whether the language plpgsql is available in the rmdb database.
If not, set it up.In the UMS Administrator, create a new data source with the following parameters:
DB type:PostgreSQL
Host: Name of the PostgreSQL Server
Port: Port of the PostgreSQL Server. (Default: 5432)
User:rmlogin
Database / SID:rmdb