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

Top comments (0)

DEV runs on 100% open source code known as Forem.

Β 
Contribute to the codebase or host your own.
Β 
Check these out! πŸ‘‡