Difference between revisions of "Install PostGreSQL Client in Linux CentOS 7"
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
<pre> | <pre> | ||
| − | [root@gejoreuy ~]# yum install https://download.postgresql.org/pub/repos/yum/ | + | [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> | ||
Revision as of 18:53, 23 July 2020
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/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
