This is the multi-page printable view of this section.
Click here to print.
Return to the regular view of this page.
Category: GIS
GIS: GeoSpatial Data Types, Operators, and Indexes, Hexagonal Indexing, OGR Data FDW, GeoIP & MobilityDB, etc…
GIS category has 19 available extensions:
1 - postgis
PostGIS geometry and geography spatial types and functions
Overview
PGDG 1st Party Extension: postgis : PostGIS geometry and geography spatial types and functions
- Latest Version: 3.5.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
postgis35_$v*
- RPM Ver :
3.5.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
- DEB Ver :
3.5.2
- DEB Deps: N/A
Packages
Installation
Install postgis via the pig CLI tool:
Install postgis via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["postgis"]}' # postgis35```
Install `postgis` [RPM](/ext/list/rpm) from **YUM** repo directly:
```bash
dnf install postgis35_17*;
dnf install postgis35_16*;
dnf install postgis35_15*;
dnf install postgis35_14*;
dnf install postgis35_13*;
Install postgis DEB from APT repo directly:
apt install postgresql-17-postgis-3 postgresql-17-postgis-3-scripts;
apt install postgresql-16-postgis-3 postgresql-16-postgis-3-scripts;
apt install postgresql-15-postgis-3 postgresql-15-postgis-3-scripts;
apt install postgresql-14-postgis-3 postgresql-14-postgis-3-scripts;
apt install postgresql-13-postgis-3 postgresql-13-postgis-3-scripts;
Enable postgis extension on PostgreSQL cluster：
CREATE EXTENSION postgis;
2 - postgis_topology
PostGIS topology spatial types and functions
Overview
PGDG 1st Party Extension: postgis : PostGIS topology spatial types and functions
- Latest Version: 3.5.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
topology
- Requires:
postgis
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
postgis35_$v*
- RPM Ver :
3.5.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
- DEB Ver :
3.5.2
- DEB Deps: N/A
Packages
Installation
Install postgis_topology via the pig CLI tool:
pig ext install postgis; # Extension Namepig ext install postgis_topology; # normalized package name
Install postgis via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["postgis"]}' # -l <cls>
Install postgis RPM from YUM repo directly:
dnf install postgis35_17*;
dnf install postgis35_16*;
dnf install postgis35_15*;
dnf install postgis35_14*;
dnf install postgis35_13*;
Install postgis DEB from APT repo directly:
apt install postgresql-17-postgis-3 postgresql-17-postgis-3-scripts;
apt install postgresql-16-postgis-3 postgresql-16-postgis-3-scripts;
apt install postgresql-15-postgis-3 postgresql-15-postgis-3-scripts;
apt install postgresql-14-postgis-3 postgresql-14-postgis-3-scripts;
apt install postgresql-13-postgis-3 postgresql-13-postgis-3-scripts;
Enable postgis_topology extension on PostgreSQL cluster：
CREATE EXTENSION postgis_topology CASCADE;
3 - postgis_raster
PostGIS raster types and functions
Overview
PGDG 1st Party Extension: postgis : PostGIS raster types and functions
- Latest Version: 3.5.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
postgis
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
postgis35_$v*
- RPM Ver :
3.5.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
- DEB Ver :
3.5.2
- DEB Deps: N/A
Packages
Installation
Install postgis_raster via the pig CLI tool:
pig ext install postgis; # Extension Namepig ext install postgis_raster; # normalized package name
Install postgis via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["postgis"]}' # -l <cls>
Install postgis RPM from YUM repo directly:
dnf install postgis35_17*;
dnf install postgis35_16*;
dnf install postgis35_15*;
dnf install postgis35_14*;
dnf install postgis35_13*;
Install postgis DEB from APT repo directly:
apt install postgresql-17-postgis-3 postgresql-17-postgis-3-scripts;
apt install postgresql-16-postgis-3 postgresql-16-postgis-3-scripts;
apt install postgresql-15-postgis-3 postgresql-15-postgis-3-scripts;
apt install postgresql-14-postgis-3 postgresql-14-postgis-3-scripts;
apt install postgresql-13-postgis-3 postgresql-13-postgis-3-scripts;
Enable postgis_raster extension on PostgreSQL cluster：
CREATE EXTENSION postgis_raster CASCADE;
4 - postgis_sfcgal
PostGIS SFCGAL functions
Overview
PGDG 1st Party Extension: postgis : PostGIS SFCGAL functions
- Latest Version: 3.5.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
postgis
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
postgis35_$v*
- RPM Ver :
3.5.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
- DEB Ver :
3.5.2
- DEB Deps: N/A
Packages
Installation
Install postgis_sfcgal via the pig CLI tool:
pig ext install postgis; # Extension Namepig ext install postgis_sfcgal; # normalized package name
Install postgis via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["postgis"]}' # -l <cls>
Install postgis RPM from YUM repo directly:
dnf install postgis35_17*;
dnf install postgis35_16*;
dnf install postgis35_15*;
dnf install postgis35_14*;
dnf install postgis35_13*;
Install postgis DEB from APT repo directly:
apt install postgresql-17-postgis-3 postgresql-17-postgis-3-scripts;
apt install postgresql-16-postgis-3 postgresql-16-postgis-3-scripts;
apt install postgresql-15-postgis-3 postgresql-15-postgis-3-scripts;
apt install postgresql-14-postgis-3 postgresql-14-postgis-3-scripts;
apt install postgresql-13-postgis-3 postgresql-13-postgis-3-scripts;
Enable postgis_sfcgal extension on PostgreSQL cluster：
CREATE EXTENSION postgis_sfcgal CASCADE;
5 - postgis_tiger_geocoder
PostGIS tiger geocoder and reverse geocoder
Overview
PGDG 1st Party Extension: postgis : PostGIS tiger geocoder and reverse geocoder
- Latest Version: 3.5.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Trusted, Can be created by user with
CREATE Privilege
- Schemas:
tiger
- Requires:
postgis, fuzzystrmatch
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
postgis35_$v*
- RPM Ver :
3.5.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
- DEB Ver :
3.5.2
- DEB Deps: N/A
Packages
Installation
Install postgis_tiger_geocoder via the pig CLI tool:
pig ext install postgis; # Extension Namepig ext install postgis_tiger_geocoder; # normalized package name
Install postgis via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["postgis"]}' # -l <cls>
Install postgis RPM from YUM repo directly:
dnf install postgis35_17*;
dnf install postgis35_16*;
dnf install postgis35_15*;
dnf install postgis35_14*;
dnf install postgis35_13*;
Install postgis DEB from APT repo directly:
apt install postgresql-17-postgis-3 postgresql-17-postgis-3-scripts;
apt install postgresql-16-postgis-3 postgresql-16-postgis-3-scripts;
apt install postgresql-15-postgis-3 postgresql-15-postgis-3-scripts;
apt install postgresql-14-postgis-3 postgresql-14-postgis-3-scripts;
apt install postgresql-13-postgis-3 postgresql-13-postgis-3-scripts;
Enable postgis_tiger_geocoder extension on PostgreSQL cluster：
CREATE EXTENSION postgis_tiger_geocoder CASCADE;
6 - address_standardizer
Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
Overview
PGDG 1st Party Extension: postgis : Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
- Latest Version: 3.5.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
postgis35_$v*
- RPM Ver :
3.5.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
- DEB Ver :
3.5.2
- DEB Deps: N/A
Packages
Installation
Install address_standardizer via the pig CLI tool:
pig ext install postgis; # Extension Namepig ext install address_standardizer; # normalized package name
Install postgis via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["postgis"]}' # -l <cls>
Install postgis RPM from YUM repo directly:
dnf install postgis35_17*;
dnf install postgis35_16*;
dnf install postgis35_15*;
dnf install postgis35_14*;
dnf install postgis35_13*;
Install postgis DEB from APT repo directly:
apt install postgresql-17-postgis-3 postgresql-17-postgis-3-scripts;
apt install postgresql-16-postgis-3 postgresql-16-postgis-3-scripts;
apt install postgresql-15-postgis-3 postgresql-15-postgis-3-scripts;
apt install postgresql-14-postgis-3 postgresql-14-postgis-3-scripts;
apt install postgresql-13-postgis-3 postgresql-13-postgis-3-scripts;
Enable address_standardizer extension on PostgreSQL cluster：
CREATE EXTENSION address_standardizer;
7 - address_standardizer_data_us
Address Standardizer US dataset example
Overview
PGDG 1st Party Extension: postgis : Address Standardizer US dataset example
- Latest Version: 3.5.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
postgis35_$v*
- RPM Ver :
3.5.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-postgis-3 postgresql-$v-postgis-3-scripts
- DEB Ver :
3.5.2
- DEB Deps: N/A
Packages
Installation
Install address_standardizer_data_us via the pig CLI tool:
pig ext install postgis; # Extension Namepig ext install address_standardizer_data_us; # normalized package name
Install postgis via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["postgis"]}' # -l <cls>
Install postgis RPM from YUM repo directly:
dnf install postgis35_17*;
dnf install postgis35_16*;
dnf install postgis35_15*;
dnf install postgis35_14*;
dnf install postgis35_13*;
Install postgis DEB from APT repo directly:
apt install postgresql-17-postgis-3 postgresql-17-postgis-3-scripts;
apt install postgresql-16-postgis-3 postgresql-16-postgis-3-scripts;
apt install postgresql-15-postgis-3 postgresql-15-postgis-3-scripts;
apt install postgresql-14-postgis-3 postgresql-14-postgis-3-scripts;
apt install postgresql-13-postgis-3 postgresql-13-postgis-3-scripts;
Enable address_standardizer_data_us extension on PostgreSQL cluster：
CREATE EXTENSION address_standardizer_data_us;
8 - pgrouting
pgRouting Extension
Overview
PGDG 1st Party Extension: pgrouting : pgRouting Extension
- Latest Version: 3.7.3
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
postgis
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pgrouting_$v*
- RPM Ver :
3.7.3
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pgrouting postgresql-$v-pgrouting-scripts
- DEB Ver :
3.7.2
- DEB Deps: N/A
Packages
Installation
Install pgrouting via the pig CLI tool:
pig ext install pgrouting
Install pgrouting via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pgrouting"]}' # -l <cls>
Install pgrouting RPM from YUM repo directly:
dnf install pgrouting_17*;
dnf install pgrouting_16*;
dnf install pgrouting_15*;
dnf install pgrouting_14*;
dnf install pgrouting_13*;
Install pgrouting DEB from APT repo directly:
apt install postgresql-17-pgrouting postgresql-17-pgrouting-scripts;
apt install postgresql-16-pgrouting postgresql-16-pgrouting-scripts;
apt install postgresql-15-pgrouting postgresql-15-pgrouting-scripts;
apt install postgresql-14-pgrouting postgresql-14-pgrouting-scripts;
apt install postgresql-13-pgrouting postgresql-13-pgrouting-scripts;
Enable pgrouting extension on PostgreSQL cluster：
CREATE EXTENSION pgrouting CASCADE;
9 - pointcloud
data type for lidar point clouds
Overview
MIXED 3rd Party Extension: pointcloud : data type for lidar point clouds
- Latest Version: 1.2.5
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pointcloud_$v*
- RPM Ver :
1.2.5
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pointcloud
- DEB Ver :
1.2.5
- DEB Deps: N/A
Packages
Installation
Install pointcloud via the pig CLI tool:
pig ext install pointcloud
Install pointcloud via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pointcloud"]}' # -l <cls>
Install pointcloud RPM from YUM repo directly:
dnf install pointcloud_17*;
dnf install pointcloud_16*;
dnf install pointcloud_15*;
dnf install pointcloud_14*;
dnf install pointcloud_13*;
Install pointcloud DEB from APT repo directly:
apt install postgresql-17-pointcloud;
apt install postgresql-16-pointcloud;
apt install postgresql-15-pointcloud;
apt install postgresql-14-pointcloud;
apt install postgresql-13-pointcloud;
Enable pointcloud extension on PostgreSQL cluster：
CREATE EXTENSION pointcloud;
10 - pointcloud_postgis
integration for pointcloud LIDAR data and PostGIS geometry data
Overview
PGDG 1st Party Extension: pointcloud : integration for pointcloud LIDAR data and PostGIS geometry data
- Latest Version: 1.2.5
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Trusted, Can be created by user with
CREATE Privilege
- Schemas: N/A
- Requires:
postgis, pointcloud
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
pointcloud_$v*
- RPM Ver :
1.2.5
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-pointcloud
- DEB Ver :
1.2.5
- DEB Deps: N/A
Packages
Installation
Install pointcloud_postgis via the pig CLI tool:
pig ext install pointcloud; # Extension Namepig ext install pointcloud_postgis; # normalized package name
Install pointcloud via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pointcloud"]}' # -l <cls>
Install pointcloud RPM from YUM repo directly:
dnf install pointcloud_17*;
dnf install pointcloud_16*;
dnf install pointcloud_15*;
dnf install pointcloud_14*;
dnf install pointcloud_13*;
Install pointcloud DEB from APT repo directly:
apt install postgresql-17-pointcloud;
apt install postgresql-16-pointcloud;
apt install postgresql-15-pointcloud;
apt install postgresql-14-pointcloud;
apt install postgresql-13-pointcloud;
Enable pointcloud_postgis extension on PostgreSQL cluster：
CREATE EXTENSION pointcloud_postgis CASCADE;
11 - h3
H3 bindings for PostgreSQL
Overview
PGDG 1st Party Extension: pg_h3 : H3 bindings for PostgreSQL
- Latest Version: 4.2.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
h3-pg_$v*
- RPM Ver :
4.1.3
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-h3
- DEB Ver :
4.2.2
- DEB Deps: N/A
Packages
Installation
Install h3 via the pig CLI tool:
pig ext install pg_h3; # Extension Namepig ext install h3; # normalized package name
Install pg_h3 via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_h3"]}' # -l <cls>
Install pg_h3 RPM from YUM repo directly:
dnf install h3-pg_17*;
dnf install h3-pg_16*;
dnf install h3-pg_15*;
dnf install h3-pg_14*;
dnf install h3-pg_13*;
Install pg_h3 DEB from APT repo directly:
apt install postgresql-17-h3;
apt install postgresql-16-h3;
apt install postgresql-15-h3;
apt install postgresql-14-h3;
apt install postgresql-13-h3;
Enable h3 extension on PostgreSQL cluster：
12 - h3_postgis
H3 PostGIS integration
Overview
PGDG 1st Party Extension: pg_h3 : H3 PostGIS integration
- Latest Version: 4.2.2
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
h3, postgis, postgis_raster
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
h3-pg_$v*
- RPM Ver :
4.1.3
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-h3
- DEB Ver :
4.2.2
- DEB Deps: N/A
Packages
Installation
Install h3_postgis via the pig CLI tool:
pig ext install pg_h3; # Extension Namepig ext install h3_postgis; # normalized package name
Install pg_h3 via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_h3"]}' # -l <cls>
Install pg_h3 RPM from YUM repo directly:
dnf install h3-pg_17*;
dnf install h3-pg_16*;
dnf install h3-pg_15*;
dnf install h3-pg_14*;
dnf install h3-pg_13*;
Install pg_h3 DEB from APT repo directly:
apt install postgresql-17-h3;
apt install postgresql-16-h3;
apt install postgresql-15-h3;
apt install postgresql-14-h3;
apt install postgresql-13-h3;
Enable h3_postgis extension on PostgreSQL cluster：
CREATE EXTENSION h3_postgis CASCADE;
13 - q3c
q3c sky indexing plugin
Overview
MIXED 3rd Party Extension: q3c : q3c sky indexing plugin
- Latest Version: 2.0.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
q3c_$v*
- RPM Ver :
2.0.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-q3c
- DEB Ver :
2.0.1
- DEB Deps: N/A
Packages
Installation
Install q3c via the pig CLI tool:
Install q3c via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["q3c"]}' # -l <cls>
Install q3c RPM from YUM repo directly:
dnf install q3c_17*;
dnf install q3c_16*;
dnf install q3c_15*;
dnf install q3c_14*;
dnf install q3c_13*;
Install q3c DEB from APT repo directly:
apt install postgresql-17-q3c;
apt install postgresql-16-q3c;
apt install postgresql-15-q3c;
apt install postgresql-14-q3c;
apt install postgresql-13-q3c;
Enable q3c extension on PostgreSQL cluster：
14 - ogr_fdw
foreign-data wrapper for GIS data access
Overview
PGDG 1st Party Extension: ogr_fdw : foreign-data wrapper for GIS data access
- Latest Version: 1.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
ogr_fdw_$v*
- RPM Ver :
1.1
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-ogr-fdw
- DEB Ver :
1.1
- DEB Deps: N/A
Packages
Installation
Install ogr_fdw via the pig CLI tool:
Install ogr_fdw via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["ogr_fdw"]}' # -l <cls>
Install ogr_fdw RPM from YUM repo directly:
dnf install ogr_fdw_17*;
dnf install ogr_fdw_16*;
dnf install ogr_fdw_15*;
dnf install ogr_fdw_14*;
dnf install ogr_fdw_13*;
Install ogr_fdw DEB from APT repo directly:
apt install postgresql-17-ogr-fdw;
apt install postgresql-16-ogr-fdw;
apt install postgresql-15-ogr-fdw;
apt install postgresql-14-ogr-fdw;
apt install postgresql-13-ogr-fdw;
Enable ogr_fdw extension on PostgreSQL cluster：
CREATE EXTENSION ogr_fdw;
15 - geoip
IP-based geolocation query
Overview
MIXED 3rd Party Extension: geoip : IP-based geolocation query
- Latest Version: 0.3.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas:
geoip
- Requires:
ip4r
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
geoip_$v
- RPM Ver :
0.3.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-geoip
- DEB Ver :
0.3.0
- DEB Deps: N/A
Packages
Installation
Install geoip via the pig CLI tool:
Install geoip via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["geoip"]}' # -l <cls>
Install geoip RPM from YUM repo directly:
dnf install geoip_17;
dnf install geoip_16;
dnf install geoip_15;
dnf install geoip_14;
dnf install geoip_13;
Install geoip DEB from APT repo directly:
apt install postgresql-17-geoip;
apt install postgresql-16-geoip;
apt install postgresql-15-geoip;
apt install postgresql-14-geoip;
apt install postgresql-13-geoip;
Enable geoip extension on PostgreSQL cluster：
CREATE EXTENSION geoip CASCADE;
16 - pg_polyline
Fast Google Encoded Polyline encoding & decoding for postgres
Overview
PIGSTY 3rd Party Extension: pg_polyline : Fast Google Encoded Polyline encoding & decoding for postgres
- Latest Version: 0.0.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can be installed into other schemas
- Trusted: Trusted, Can be created by user with
CREATE Privilege
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_polyline_$v
- RPM Ver :
0.0.1
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-polyline
- DEB Ver :
0.0.1
- DEB Deps: N/A
Packages
Installation
Install pg_polyline via the pig CLI tool:
pig ext install pg_polyline
Install pg_polyline via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_polyline"]}' # -l <cls>
Install pg_polyline RPM from YUM repo directly:
dnf install pg_polyline_17;
dnf install pg_polyline_16;
dnf install pg_polyline_15;
dnf install pg_polyline_14;
dnf install pg_polyline_13;
Install pg_polyline DEB from APT repo directly:
apt install postgresql-17-pg-polyline;
apt install postgresql-16-pg-polyline;
apt install postgresql-15-pg-polyline;
apt install postgresql-14-pg-polyline;
apt install postgresql-13-pg-polyline;
Enable pg_polyline extension on PostgreSQL cluster：
CREATE EXTENSION pg_polyline;
17 - pg_geohash
Handle geohash based functionality for spatial coordinates
Overview
PIGSTY 3rd Party Extension: pg_geohash : Handle geohash based functionality for spatial coordinates
- Latest Version: 1.0
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires: N/A
RPM / DEB
- RPM Repo: PIGSTY
- RPM Name:
pg_geohash_$v*
- RPM Ver :
1.0
- RPM Deps: N/A
- DEB Repo: PIGSTY
- DEB Name:
postgresql-$v-pg-geohash
- DEB Ver :
1.0
- DEB Deps: N/A
Packages
Installation
Install pg_geohash via the pig CLI tool:
pig ext install pg_geohash
Install pg_geohash via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["pg_geohash"]}' # -l <cls>
Install pg_geohash RPM from YUM repo directly:
dnf install pg_geohash_17*;
dnf install pg_geohash_16*;
dnf install pg_geohash_15*;
dnf install pg_geohash_14*;
dnf install pg_geohash_13*;
Install pg_geohash DEB from APT repo directly:
apt install postgresql-17-pg-geohash;
apt install postgresql-16-pg-geohash;
apt install postgresql-15-pg-geohash;
apt install postgresql-14-pg-geohash;
apt install postgresql-13-pg-geohash;
Enable pg_geohash extension on PostgreSQL cluster：
CREATE EXTENSION pg_geohash;
18 - mobilitydb
MobilityDB geospatial trajectory data management & analysis platform
Overview
PGDG 1st Party Extension: mobilitydb : MobilityDB geospatial trajectory data management & analysis platform
- Latest Version: 1.1.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Can not install to arbitrary schema
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
postgis
RPM / DEB
- RPM Repo: None
- RPM Name:
N/A
- RPM Ver : N/A
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-mobilitydb
- DEB Ver :
1.2.0
- DEB Deps: N/A
Packages
Installation
Install mobilitydb via the pig CLI tool:
pig ext install mobilitydb
Install mobilitydb via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["mobilitydb"]}' # -l <cls>
Install mobilitydb DEB from APT repo directly:
apt install postgresql-17-mobilitydb;
apt install postgresql-16-mobilitydb;
apt install postgresql-15-mobilitydb;
apt install postgresql-14-mobilitydb;
apt install postgresql-13-mobilitydb;
Enable mobilitydb extension on PostgreSQL cluster：
CREATE EXTENSION mobilitydb CASCADE;
19 - earthdistance
calculate great-circle distances on the surface of the Earth
Overview
CONTRIB Built-in Extension: earthdistance : calculate great-circle distances on the surface of the Earth
- Latest Version: 1.1
- Postgres Support:
17,16,15,14,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION DDL
- Relocatable: Unknown
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
cube
RPM / DEB
PostgreSQL Built-in Contrib Extension
Packages
| OS |
Arch |
PG17 |
PG16 |
PG15 |
PG14 |
PG13 |
el8 |
x86_64 |
|
|
|
|
|
el8 |
aarch64 |
|
|
|
|
|
el9 |
x86_64 |
|
|
|
|
|
el9 |
aarch64 |
|
|
|
|
|
d12 |
x86_64 |
|
|
|
|
|
d12 |
aarch64 |
|
|
|
|
|
u22 |
x86_64 |
|
|
|
|
|
u22 |
aarch64 |
|
|
|
|
|
u24 |
x86_64 |
|
|
|
|
|
u24 |
aarch64 |
|
|
|
|
|
Installation
Extension earthdistance is PostgreSQL Built-in Contrib Extension which is installed along with the kernel/contrib.
Install earthdistance RPM from YUM repo directly:
dnf install postgresql17-contrib;
dnf install postgresql16-contrib;
dnf install postgresql15-contrib;
dnf install postgresql14-contrib;
dnf install postgresql13-contrib;
Install earthdistance DEB from APT repo directly:
apt install postgresql-17;
apt install postgresql-16;
apt install postgresql-15;
apt install postgresql-14;
apt install postgresql-13;
Enable earthdistance extension on PostgreSQL cluster：
CREATE EXTENSION earthdistance CASCADE;