Shulou(Shulou.com)06/01 Report--

1. Yum installs pgsql10

II.

1. Yum installs pgsql10

Install pgsql first

Environment centos 7 64-bit

Database: pg10dev

Reference website:

Http://blog.csdn.net/silenceray/article/details/70577610

Create a user

[root@localhost ~] # useradd postgres

Configure your yum repository

[root@localhost ~] # vim / etc/yum.repos.d/CentOS-Base.repo

Add between [base] and [updates] sections:

Exclude=postgresql*

Install the rpm file for pg

[root@localhost ~] # yum localinstall https://download.postgresql.org/pub/repos/yum/testing/10/redhat/rhel-7-x86_64/pgdg-centos10-10-1.noarch.rpm

Install the pg database

[root@localhost ~] # yum list postgresql*

[root@localhost ~] # yum install postgresql10-server.x86_64

[root@localhost ~] # mkdir postgres / var/lib/pgsql/10/data

Initialize the database

[root@localhost ~] # / usr/pgsql-10/bin/postgresql10-setup initdb

Initializing database... OK

[root@localhost ~] # su-postgres

[postgres@localhost] $/ usr/pgsql-10/bin/pg_ctl-D / var/lib/pgsql/10/data start

[postgres@localhost] $/ usr/pgsql-10/bin/psql-p 5432

Psql (10devel)

Enter "help" for help.

Postgres=#

Installation complete!

Configure pgsql so that clients can access

2.1 change password

(1) su postgres

(2) psql-U postgres-p5433

(3) alter user postgres with password 'postgres'

2.2 modify the configuration file to allow remote login.

In the same directory as pg_hba.conf, postgresql.conf

Listen_addresses = 'localhost', change to listen_addresses =' *'

2.3 modify Port

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.