Centos 7 install PostgreSQL

This article only talks about the installation of PostgreSQL under CentOS 7.x. For other systems, please check: https://www.postgresql.org/download

The version of PostgreSQL used is: PostgreSQL 10

Install the repository

yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-1.noarch.rpm

Install the client

yum install postgresql10

Install the server

yum install postgresql10-server

Verify that the installation is successful

rpm -aq| grep postgres

The output is as follows:

Initialize the database

/usr/pgsql-10/bin/postgresql-10-setup initdb

Enable auto start

systemctl enable postgresql-10
systemctl start postgresql-10

Configure firewall

firewall-cmd --permanent --add-port=5432/tcp  
firewall-cmd --permanent --add-port=80/tcp  
firewall-cmd --reload

Modify user password

 su -postgres switch user, the prompt will change to'-bash-4.2$'
 psql -U postgres logs in to the database, and the prompt becomes'postgres=#'
 ALTER USER postgres WITH PASSWORD 'postgres'Set the postgres user password to postgres
 \ q Exit the database

Enable remote access

  vim /var/lib/pgsql/10/data/postgresql.conf
 modify#listen_addresses ='localhost'For listen_addresses='*'
 Of course, here&#39;*&#39;You can also change to any server IP you want to open

Trust remote connection

 vi m/var/lib/pgsql/10/data/pg_hba.conf
 Modify the following content to trust the specified server connection
 # IPv4 local connections:
 host    all            all      127.0.0.1/32      trust
 host    all            all      192.168.157.1/32 (IP of the server to be connected) trust

Restart service

systemctl restart postgresql-10

Connect using DBMS software

Navicat is used here

connection succeeded: