postgresql + POSTGIS

Postgresql安装：

yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm
yum install postgresql10
yum install postgresql10-server
/usr/pgsql-10/bin/postgresql-10-setup initdb
systemctl enable postgresql-10
systemctl start postgresql-10
su - postgres
psql -U postgres
alter user postgres with password postgres;
\q  
exit退出
cd /var/lib/pgsql/10/data
vi postgresql.conf   修改listen_addresses = '*'   
systemctl start firewalld
firewall-cmd --zone=public --add-port=5432/tcp --permanent

vi pg_hba.conf
将ip4连接下面修改成：host   all    all 0.0.0.0/0 md5

重启systemctl restart postgresql-10

POSTGIS安装
yum -y install epel-release
sudo rpm -ivh http://yum.postgresql.org/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpm
sudo yum install postgis2_95
sudo yum install postgis2_95-client

su postgres
/usr/pgsql-9.5/bin/psql -p 5432
CREATE DATABASE gistest;
\connect gistest;
yum install ogr_fdw95
yum install pgrouting_95