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.


    PRODUCT:

    Remedy Single Sign On


    COMPONENT:

    Remedy Single Sign On


    APPLIES TO:

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



    QUESTION:

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


    ANSWER:

     

    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:   https://tecadmin.net/install-postgresql-server-centos/

    Step 1 – Add Postgres Yum Repository


              rpm -Uvh https://yum.postgresql.org/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
     
    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/multi-user.target.wants/postgresql-10.service 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.
              postgres=#


    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              127.0.0.1/32                   
    trust
              # IPv6 local connections:
                          host   all                   all             ::1/128                             
    trust

      


    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:

    000170909


    Article Type:

    FAQ/Procedural



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