Difference between revisions of "Install PostGreSQL Client in Linux CentOS 7"

From Gejoreuy
Jump to navigation Jump to search
 
(One intermediate revision by the same user not shown)
Line 4: Line 4:
  
 
== Install PostGreSQL Client ==
 
== Install PostGreSQL Client ==
 +
 +
Just follow these steps below.
  
 
<pre>
 
<pre>
[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 https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
 
[root@gejoreuy ~]# yum install postgresql10
 
[root@gejoreuy ~]# yum install postgresql10
 
</pre>
 
</pre>

Latest revision as of 22:18, 20 July 2021

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