6月份的时候应大家需求整理了一篇
废话参考以上文章,进入CentOS下PostgreSQL和PostGIS安装流程:
1 安装篇
安装前首先查询自己ArcGIS支持的PostgreSQL版本,譬如我的ArcGIS Desktop10.8支持9.6/10/11三个版本,同时查询与之对应的PostGIS版本。
![图片[1]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/06/20220619124945944.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
本次安装环境:
PostgreSQL版本:
PostGIS版本:
CentOS版本:
1.1 安装PostgreSQL
官网安装教程:https://www.postgresql.org/download/linux/redhat
![图片[2]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125154934651.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
(1)安装PostgreSQL存储库RPM(更新RPM源)
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
![图片[3]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125162220335.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
(2)安装PostgreSQL
sudo yum install -y postgresql11-server
![图片[4]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125163613857.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
![图片[5]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125163847416.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
(3)初始化数据库并设置开机启动
sudo /usr/pgsql-11/bin/postgresql-11-setup initdb
sudo systemctl enable postgresql-11
sudo systemctl start postgresql-11
![图片[6]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125163920720.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
(4)设置postgres用户密码
安装 PostgreSQL 后默认生成 postgres 数据库和默认用户 postgres (此postgres为数据库的用户),默认 postgres 用户密码为空,需设置。
su - postgres
psql -U postgres
alter user postgres with encrypted password '123';
![图片[7]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125164022648.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
退出psql:
\q
exit
![图片[8]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125164230148.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
(5)配置PostgreSQL防火墙、端口,并开启远程访问
(6)使用数据库连接工具测试连接
![图片[9]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125173034300.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
1.2 安装PostGIS
(1)安装PostGIS存储库RPM(更新RPM源)
rpm -ivh https://mirrors.aliyun.com/epel/epel-release-latest-7.noarch.rpm
![图片[10]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125173845188.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
(2)查询可供使用的PostGIS版本
查询的目的是确认提供了与PostgreSQL对应版本的PostGIS,可略过。
yum search postgis
![图片[11]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125175531178.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
PostgreSQL与PostGIS版本兼容关系(截至2022年11月26日):
PostgreSQL version | PostGIS 2.5 | PostGIS 3.0 | PostGIS 3.1 | PostGIS 3.2 | PostGIS 3.3 | PostGIS 3.4 |
PostGIS release date | 2018/09/23 | 2019/10/20 | 2020/12/18 | 2021/12/18 | 2022/08/27 | 20XX/XX/XX |
16 | No | No | No | No | Yes* | Yes |
15 | No | No | No | Yes* | Yes | Yes |
14 | No | No | Yes | Yes | Yes | Yes |
13 | No | Yes | Yes | Yes | Yes | Yes |
12 | Yes | Yes | Yes | Yes | Yes | Yes |
11 | Yes | Yes | Yes | Yes | Yes | No |
(3)安装PostGIS
yum install -y postgis30_11.x86_64
![图片[12]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125175751540.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
![图片[13]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125181502345.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
(4)开启pgsql拓展
//开启插件
# su postgres
# psql
//开启pgsql的插件
postgres=# create extension postgis;
postgres=# create extension postgis_topology;
postgres=# create extension fuzzystrmatch;
postgres=# create extension address_standardizer;
postgres=# create extension address_standardizer_data_us;
postgres=# create extension postgis_tiger_geocoder;
//查看版本,验证安装是否成功
postgres=# SELECT PostGIS_full_version();
![图片[14]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125183429109.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
1.3 安装pgRouting
(1)查询可供使用的pgrouting版本
yum search pgrouting
![图片[15]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125184047588.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
(2)安装pgRouting
yum install -y pgrouting_11.x86_64
![图片[16]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125184232259.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
(3)查看已安装的拓展
![图片[17]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125184649875.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
2 ST_Geometry
从位于 ArcGIS Desktop 安装位置中的 DatabaseSupport 目录复制新库,并将其放置在 PostgreSQL lib 目录中。
本教程 PostgreSQL 安装在 Linux 服务器上,则以根用户身份登录服务器,并将 st_geometry.so 文件复制到 /usr/pgsql-11/lib 目录中。
![图片[18]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125192237553.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
3 创建地理数据库
3.1 创建地理数据库
可以使用创建企业级地理数据库地理处理工具在 PostgreSQL 中创建数据库、sde 用户、sde 方案及地理数据库。
- 启动 ArcGIS Desktop 客户端或 ArcGIS Pro,然后打开创建企业级地理数据库工具。
- 需要以 postgres 超级用户身份连接 PostgreSQL 数据库集群来提供信息,以创建数据库和 sde 用户。 此外,还必须指向在授权 ArcGIS Server 站点时生成的密钥代码文件。可以使用创建企业级地理数据库工具帮助确定必须提供的信息。
- 单击确定 (ArcMap) 或运行 (ArcGIS Pro)。
在 PostgreSQL 中创建数据库、sde 用户、sde 方案及名为
![图片[19]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125193043869.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
3.2 连接至地理数据库
![图片[20]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125193350446.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
![图片[21]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125193714434.png?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
![图片[22]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125195428750.jpg?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
![图片[23]-协同编辑・GISer也能居家办公丨ArcGIS直连PostgreSQL(Linux篇)-地理信息云](https://kodo.giscloud.com.cn/web/2022/11/20221125195428426.jpg?imageMogr2/auto-orient/thumbnail/1000x/blur/1x0/quality/100|watermark/1/image/aHR0cHM6Ly9rb2RvLmdpc2Nsb3VkLmNvbS5jbi93ZWIvMjAyMi8wOS8yMDIyMDkyNzE0NDgxNTYyMS5wbmc=/dissolve/30/gravity/SouthEast/dx/20/dy/10|imageslim)
4 拓展知识
关于创建及连接地理数据库的更多详细信息,请参考:
关于CentOS如何修改固定ip地址,可参考:
暂无评论内容