centos7安装pg10

安装

yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-1.noarch.rpm
yum install postgresql10
yum install postgresql10-server
/usr/pgsql-10/bin/postgresql10-setup initdb
systemctl enable postgresql-10
systemctl start postgresql-10

修改配置文件

/var/lib/pgsql/10/data/postgresql.conf
listen_addresses = '*'


/var/lib/pgsql/10/data/pg_hba.conf
# IPv4 local connections:
host    all             all             0.0.0.0/0            trust


systemctl restart postgresql-10

创建用户

su - postgres
psql

postgres=# CREATE USER benchmarksql WITH ENCRYPTED PASSWORD 'changeme';
CREATE ROLE
postgres=# CREATE DATABASE benchmarksql OWNER benchmarksql;
CREATE DATABASE