Install PostGreSQL Client in Linux CentOS 7

From Gejoreuy
Jump to navigation Jump to search

Purpose

We want our CentOS 7 machine act as database client and can access a PostGreSQL database.

Install PostGreSQL Client

[root@gejoreuy ~]# yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-redhat10-10-2.noarch.rpm
[root@gejoreuy ~]# yum install postgresql10

How to Access PostGreSQL DB

[root@gejoreuy ~]# psql -h database_hostname -p port_number -d database_name -U user_name