Configure PostgreSQL Database for UMDS on Linux

Install and configure a PostgreSQL database instance on the Linux-based machine where you plan to install Update Manager Download Service (UMDS).

Prerequisites

• Verify PostgreSQL database instance of a supported version is installed on the system, and that the Linux system is also of a supported type. See Supported Linux-Based Operating Systems and Databases for Installing UMDS
• Verify you have PostgreSQL database user credentials.
• Verify that the UMDS installation directory is different from the patch store directory.

Procedure

1. In the Linux machine, open the Command Shell.
2. Log in as a PostgreSQL user, and create a database instance and a database user, by running the following commands:

   su - postgres
   createdb <database_name>
   createuser -d -e -r <database_username> -P
   Pwd: <database_password>

3. Navigate to the folder that contains the PostgreSQL configuration file pg_hba.conf.

   Linux system	Default Location
   Ubuntu 14.0.4	/etc/postgresql/<postgres_version>/main/pg_hba.conf
   Red Hat Enterprise Linux 7.0	/var/lib/pgsql/<postgres_version>/data/pg_hba.conf

4. In the PostgreSQL configuration file, enable password authentication for the database user by inserting the following line right above local all all peer.

   #TYPE	DATABASE	USER	ADDRESS	METHOD
   local	<database_name>	<database_username>		md5

5. Log out as a PostgreSQL user, by running the following command:

   logout

6. Create a configuration file /etc/odbcinst.ini.
7. Depending on the Linux system, navigate to the ODBC driver files psqlodbcw.so or libodbcpsqlS.so.

   Linux system	Default Location
   Ubuntu 14.0.4	/usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so
   Red Hat Enterprise Linux 7.0	/usr/lib64/libodbcpsqlS.so

8. Add driver paths files to /etc/odbcinst.ini.

   Linux system	Command
   Ubuntu 14.0.4	[PostgreSQL] Description=PostgreSQL ODBC driver (Unicode version) Driver=/usr/lib/x86_64-linux-gnu/odbc/psqlodbcw.so Debug=0 CommLog=1 UsageCount=1
   Red Hat Linux 7.0	[PostgreSQL] Description=PostgreSQL ODBC driver (Unicode version) Driver64=<path>/psqlodbcw.so Setup64=<path>/libodbcpsqlS.so Debug=0 CommLog=1 UsageCount=1

9. Create a system file /etc/odbc.ini.
10. Add the following content to /etc/odbc.ini.

    [UMDS_DSN]
    ;DB_TYPE = PostgreSQL
    ;SERVER_NAME = localhost
    ;SERVER_PORT = 5432
    ;TNS_SERVICE = <database_name>
    ;USER_ID = <database_username>
    Driver = PostgreSQL
    DSN = UMDS_DSN
    ServerName = localhost
    PortNumber = 5432
    Server = localhost
    Port = 5432
    UserID = <database_username>
    User = <database_username>
    Database = <database_name>

11. Create a symbolic link between the UMDS and the PostgreSQL, by running the following command:

    ln -s /var/run/postgresql/.s.PGSQL.5432 /tmp/.s.PGSQL.5432

What to do next

When installing UMDS on a Linux-based system, use the PostgreSQL database instance that you configured here.