DEV Community

jerry80409
jerry80409

Posted on

Yum Install Postgres 11 client

CentOS 7

# -U Upgrade 
# -v Show verbose stdout
# -h Show hash marks
rpm -Uvh https://yum.postgresql.org/11/redhat/rhel-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Install PostgreSQL Client

# -y Always answer yes for all questions
# and clean cached package
yum -y install postgresql11 && yum clean

Check psql command

psql --version
psql (PostgreSQL) 11.5

Connect your Postgres database

# $PG_HOST: Hostname of Postgres
# $PG_PORT: Default is 5432
# $PG_USER: User of Postgres
psql -h $PG_HOST -p $PG_PORT -U $PG_USER
Password for user wms: # enter the password

Discussion (0)