Shulou(Shulou.com)05/31 Report--

This article mainly explains "what is the Yum+rpm installation method of PostgreSQL 10.12". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Now let the editor take you to learn "what is the Yum+rpm installation method of PostgreSQL 10.12"?

Download Yum Warehouse:

Https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Install the yum repository:

[root@open_source ~] # lsanaconda-ks.cfg pgdg-redhat-repo- latest.noarch.rpm [root @ open_source ~] # rpm-ivh pgdg-redhat-repo-latest.noarch.rpm warning: pgdg-redhat-repo-latest.noarch.rpm: Header V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEYPreparing... # # [100%] Updating / installing... 1:pgdg-redhat-repo-42.0-6 # # [root@open_source] # ls-rtl / etc/yum.repos.d/pgdg-redhat-all.repo-rw-r--r-- 1 root root 5904 Sep 27 09:04 / etc/yum.repos.d/pgdg-redhat-all.repo

Install the database through yum:

[root@open_source ~] # yum install-y Postgresql10 [root @ open_source ~] # yum install postgresql10-server

Initialize the database:

[root@open_source ~] # / usr/pgsql-10/bin/postgresql-10-setup initdb

Configure to enable startup:

[root@open_source ~] # systemctl enable postgresql-10

Start the database:

[root@open_source ~] # systemctl start postgresql-10

Do not restrict any hosts and allow remote login:

[root@open_source ~] # vi / var/lib/pgsql/10/data/postgresql.conf modify listen_addresses ='*'

To modify the pg.hba file, you need to restart the service:

[root@open_source ~] # vim / var/lib/pgsql/11/data/pg_hba.conf add host all all 0.0.0.0 md5 to this, I believe you have a deeper understanding of "what is the Yum+rpm installation method of PostgreSQL 10.12", you might as well do it in practice! Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.