pg无须安装,直接使用名址库的pg。
参考:http://blog.chinaunix.net/uid-26600678-id-4005071.html
pg版本11
yum install -y gcc gcc-c++ epel-release llvm5.0 llvm5.0-devel clang libicu-devel perl-ExtUtils-Embed zlib-devel openssl openssl-devel pam-devel libxml2-devel libxslt-devel openldap-devel systemd-devel tcl-devel python-devel
yum install -y llvm5.0 llvm5.0-devel
yum -y install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm
yum -y install postgresql11
yum install postgresql11-serve
yum install postgresql11-libs
yum install postgresql11-contrib
yum install postgresql11-devel
-
-
- 目录
-
使用 yum 自动安装所以安装位置都在
cd /usr/pgsql-11
/usr/pgsql-11/bin/postgresql-11-setup initdb -D /data/pgsql/data
passwd postgres
su postgres
createuser --interactive
安装完成后需要进行配置
a、首先去除主要本机可以访问postgresql的限制
vi /var/lib/pgsql/11/data/postgresql.conf
修改
listen_addresses = '*'
b、开通远程账户访问
vi /var/lib/pgsql/11/data/pg_hba.conf
在最后一行加入
host all all 0.0.0.0/0 md5
c、启动服务
systemctl start postgresql-11
d、修改postgres密码
sudo -u postgres psql
ALTER USER postgres WITH PASSWORD 'postgres';
systemctl enable postgresql-11
systemctl enable postgresql-11.service
systemctl start postgresql-11.service
systemctl status postgresql-11.service
firewall-cmd --zone=public --add-port=5432/tcp --permanent
firewall-cmd --reload
postgis25_11.x86_64
yum list postgis*
yum install postgis25_11.x86_64 postgis25_11-client.x86_64 postgis25_11-devel.x86_64 postgis25_11-docs.x86_64 postgis25_11-utils.x86_64
在库里,执行:CREATE EXTENSION postgis
运行不报错则代表成功: select st_geomfromtext('point(0 0)', 4326)
命令参考:
https://blog.csdn.net/wling_89/article/details/8072016
https://blog.csdn.net/pg_hgdb/article/details/79168060
pg_dump -Fc postaladdr > postaladdr.dump
pg_restore -d newdb db.dump