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