Rocky Linux 9.4 中PostgreSQL 16.3编译安装PostGIS 3.4.2

##

Rocky Linux 9.4 中PostgreSQL 16.3编译安装PostGIS 3.4.2

1、插件验证

[root@pgdb01 ~]# cat /etc/rocky-release
Rocky Linux release 9.4 (Blue Onyx)
[root@pgdb01 ~]# su - postgres
[postgres@pgdb01:/home/postgres]$psql pgis
psql (16.3)
Type "help" for help.

pgis=# SELECT name, default_version,installed_version
FROM pg_available_extensions WHERE name LIKE 'postgis%' or name LIKE 'address%';
             name             | default_version | installed_version
------------------------------+-----------------+-------------------
 postgis_raster               | 3.4.2           | 3.4.2
 postgis_tiger_geocoder       | 3.4.2           | 3.4.2
 postgis_topology             | 3.4.2           | 3.4.2
 address_standardizer         | 3.4.2           | 3.4.2
 postgis_sfcgal               | 3.4.2           | 3.4.2
 address_standardizer_data_us | 3.4.2           | 3.4.2
 postgis                      | 3.4.2           | 3.4.2
(7 rows)

pgis=# \dx
                                                                       List of installed extensions
             Name             | Version |   Schema   |                                                     Description
------------------------------+---------+------------+---------------------------------------------------------------------------------------------------------------------
 address_standardizer         | 3.4.2   | public     | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
 address_standardizer_data_us | 3.4.2   | public     | Address Standardizer US dataset example
 fuzzystrmatch                | 1.2     | public     | determine similarities and distance between strings
 plpgsql                      | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis                      | 3.4.2   | public     | PostGIS geometry and geography spatial types and functions
 postgis_raster               | 3.4.2   | public     | PostGIS raster types and functions
 postgis_sfcgal               | 3.4.2   | public     | PostGIS SFCGAL functions
 postgis_tiger_geocoder       | 3.4.2   | tiger      | PostGIS tiger geocoder and reverse geocoder
 postgis_topology             | 3.4.2   | topology   | PostGIS topology spatial types and functions
(9 rows)

2、数据验证

3、总结

在Rocky Linux 9.4 中PostgreSQL 16.3编译安装PostGIS 3.4.2需要处理一些兼容性问题。