Download the required RPMs from the below site and install the rpms using “rpm -ivh”

https://yum.postgresql.org/rpmchart.php

Example., rpm –ivh postgresql11*

Setting Environmental Variables

Add the following two lines in /home/postgres/.bash_profile and do . .bash_profile.

POSTGRES_HOME=/usr/local/pgsql; export POSTGRES_HOME

PATH=$POSTGRES_HOME/bin:$PATH; export PATH

psql Environment Var iables

Command- Line          Opt ion               Environment Var iable  Meaning

-d <dbname>      PGDATABASE           Name of database to connect to

-h <host>             PGHOST                     Name of host to connect to

-p <port>             PGPORT                     Por t number to connect to

-U <user>            PGUSER                     PostgreSQL Username

If you get below error while installing in your machine, do follow the below steps

Problem making SSL Connection

1) yum-config-manager –disable centrify.repo
2) yum clean all
3) yum update yum
4) yum update curl
5) yum update openssl
6) yum update nss
7) yum-config-manager –enable centrify.repo