系统环境说明:
[root@slave1 ~]# cat /etc/redhat-release
CentOS Linux release 7.4.1708 (Core)
开始
1、Postgresql12的安装
https://www.postgresql.org/download/linux/redhat/
1、下载安装
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
yum install postgresql12
yum install postgresql12-server
yum install postgresql12-libs
yum install postgresql12-contrib
yum install postgresql12-devel
2、数据库初始化与设置自启动
/usr/pgsql-12/bin/postgresql-12-setup initdb
systemctl enable postgresql-12
systemctl start postgresql-12
3、编辑远程访问
cd /var/lib/pgsql/12/data
vi postgresql.conf
修改前:
#listen_address = ‘localhost’
i进入,下移光标
修改为 listen_address = ‘*’ 注意:这里将#去掉
Esc退出编辑模式,shift和:键,输入wq进行保存并退出,q表示只退出不保存
vi pg_hba.conf
添加IPv4
host all all 0.0.0.0/32 md5
4、重新启动服务
systemctl restart postgresql-12
退出当前文件回到根目录
cd /
5、登录数据库
su postgres
psql –U postgres
\password //修改密码
\q 退出postgres命令
6、卸载
yum remove postgresql*
2、Postgis的安装
yum install postgis30_12
新建库,添加postgis扩展
create extension postgis; //sql语句必须以;结尾
\q退出postgres命令
Logout或者exit退出bash
新建用户
create user map_tz with password 'dl123';
新建库
create database dl owner map_tz;
赋权限
grant all privileges on database dl to map_tz;
添加postgis扩展
create extension postgis;
create extension postgis_topology;
最后
结果如图
postgresql.png
网友评论