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

Just follow these steps below. 

[root@gejoreuy ~]# yum install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.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
Retrieved from "https://gejoreuy.com/index.php?title=Install_PostGreSQL_Client_in_Linux_CentOS_7&oldid=2047"