Page Comparison

...

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.

   Info
   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.
8. 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