https://www.postgis.net/
PostGIS adds support for geographic objects to the PostgreSQL object-relational database. In effect, PostGIS "spatially enables" the PostgreSQL server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or Oracle's Spatial extension. PostGIS follows the OpenGIS "Simple Features Specification for SQL" and has been certified as compliant with the "Types and Functions" profile.
PostGIS uses two digit version numbers like 3.4, 3.5, etc. Traditionally there is a new major release every year along with (but not strictly tied to) the PostgreSQL major release. The PostgreSQL RPM repository uses both PostGIS and PostgreSQL version numbers in the RPM packages. For example PostGIS 3.5 for PostgreSQL 17 is named as postgis35_17. Similarly PostGIS 3.2 for PostgreSQL 15 is named as postgis32_15.
PostGIS provides the following subpackages:
Install PGDG repository from: https://yum.postgresql.org/repopackages/
PostGIS heavily depends on the EPEL repository for some packages on these platforms. Users must install the EPEL repo RPM along with PGDG repo RPMs to satisfy dependencies. Please visit our EPEL support page for details.
OS | Command |
---|---|
RHEL / Rocky Linux / AlmaLinux / Fedora | dnf install postgis35_17 (or change the version as described above)
dnf install postgis35_17-gui (or change "gui" for any subpackage described above) |
Connect to the database that you want to create the extension as superuser (except postgis_tiger_geocoder
) and run:
CREATE EXTENSION postgis;
# Main extensionCREATE EXTENSION postgis_raster;
# PostGIS raster types and functionsCREATE EXTENSION postgis_sfcgal;
# PostGIS SFCGAL functionsCREATE EXTENSION postgis_tiger_geocoder CASCADE;
# PostGIS tiger geocoder and reverse geocoder. CASCADE is needed for the fuzzystrmatch extensionCREATE EXTENSION postgis_tiger_topology;
# PostGIS topology spatial types and functions
PostGIS version | PostgreSQL version(s) | OS version | Arch | Status |
---|---|---|---|---|
3.5 | 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
3.5 | 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
3.5 | 17,16,15,14,13 | Fedora Linux | x86_64 | Available |
3.4 | 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
3.4 | 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
3.4 | 17,16,15,14,13 | Fedora Linux | x86_64 | Available |
3.3 | 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
3.3 | 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
3.3 | 17,16,15,14,13 | Fedora Linux | x86_64 | Available |
3.2 | 15,14,13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
3.2 | 15,14,13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
3.2 | 15,14,13 | Fedora Linux | x86_64 | Available |
3.1 | 14,13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
3.1 | 14,13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
3.1 | 14,13 | Fedora Linux | x86_64 | Available |
3.0 | 13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
3.0 | 13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
3.0 | 13 | Fedora Linux | x86_64 | Available |