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

Prerequisites

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.