How to Install and configure Postgresql 10 Database for RSSO 19.08

Version 2
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    Remedy Single Sign On


    Remedy Single Sign On


    As of RSSO 19.08 in which is now compatible with Postgres 10


    This is a guide line to install and configure Postgresql 10 in linux RH7.5 to use it for RSSO 19.08. 



    If you install Postgresql 10 in RHEL 7.5 for various purposes where RSSO 19.08 is in target, I recommend you to follow below helpful steps given in this external url:

    Step 1 – Add Postgres Yum Repository

              rpm -Uvh
    Step 2 – Install PostgreSQL 10 Server

              yum install postgresql10-server postgresql10

    Step 3 – Initialize PGDATA 

               /usr/pgsql-10/bin/postgresql-10-setup initdb

    Step 4 – Start PostgreSQL Server

              systemctl start postgresql-10.service
              systemctl enable postgresql-10.service

              Output: Created symlink from /etc/systemd/system/ to /usr/lib/systemd/system/postgresql-10.service.
    Step 5 – Verify PostgreSQL Installation

              After completing above steps, you have installed PostgreSQL 10 on your server, Let’s log in to postfix to verify that installation completed successfully.
              su - postgres -c "psql"
              psql (10.0)
              Type "help" for help.

    You may create a password for user postgres for security purpose.

              postgres=# \password postgres

    IMPORTANT: You need to ensure you modify this file /var/lib/pgsql/10/data/pg_hba.conf and change indent setting to trust in the IPv4 and IPv6 settings due to the default settings are set as Indent which prevents external connections due not being trusted.
              $ vi /var/lib/pgsql/10/data/pg_hba.conf


              # TYPE  DATABASE        USER            ADDRESS                 METHOD

              # "local" is for Unix domain socket connections only
                           local  all                   all                                                      peer
              # IPv4 local connections:
                           host  all                    all                       
              # IPv6 local connections:
                          host   all                   all             ::1/128                             


    Otherwise you will not be able to connect to database and get errors during the installation like below:

    "Unable connect to database with administrator's credentials and URL jdbc:postgresql://localhost:5432/ Cause: FATAL: Ident authentication failed for user "postgres" "

    Once you modify the connection type you need to restart the service and run the RSSO Installer as usual.


    Article Number:


    Article Type:


      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles