Learn how to – Install PostGIS on Rocky Linux 8|CentOS 8|AlmaLinux 8

Learn how to – Install PostGIS on Rocky Linux 8|CentOS 8|AlmaLinux 8.

This guide will walk you through the steps of installing PostGIS onRocky Linux 8|CentOS 8|AlmaLinux 8 Linux. PostGIS is a PostgreSQL database extension which allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS is an open source software licensed under a Creative Commons Attribution-Share Alike 3.0 License.

PostGIS has support for GiST-based R-Tree spatial indexes and functions which aids in analysis and processing of GIS objects. Below are the core features of PostGIS.

Features of PostGIS

The PostGIS 2+ series provides:

• Processing and analytic functions for both vector and raster data for splicing, dicing, morphing, reclassifying, and collecting/unioning with the power of SQL
• raster map algebra for fine-grained raster processing
• Spatial reprojection SQL callable functions for both vector and raster data
• Support for importing / exporting ESRI shapefile vector data via both commandline and GUI packaged tools and support for more formats via other 3rd-party Open Source tools
• Packaged command-line for importing raster data from many standard formats: GeoTiff, NetCDF, PNG, JPG to name a few
• Rendering and importing vector data support functions for standard textual formats such as KML,GML, GeoJSON,GeoHash and WKT using SQL
• Rendering raster data in various standard formats GeoTIFF, PNG, JPG, NetCDF, to name a few using SQL
• Seamless raster/vector SQL callable functions for extrusion of pixel values by geometric region, running stats by region, clipping rasters by a geometry, and vectorizing rasters
• 3D object support, spatial index, and functions
• Network Topology support
• Packaged Tiger Loader / Geocoder/ Reverse Geocoder / utilizing US Census Tiger data

Follow the steps below to install PostGIS on Rocky Linux 8|CentOS 8|AlmaLinux 8 Linux system

Step 1: Install PostgreSQL Database server

PostgreSQL is a dependency for using PostGIS features. Install PostgreSQL on CentOS 8 using our guide below.

• install PostgreSQL on Rocky Linux 8|CentOS 8|AlmaLinux 8
• Install PostgreSQL 14 on Rocky Linux 8|AlmaLinux 8|CentOS 8

Step 2: Install PostGIS onRocky Linux 8|CentOS 8|AlmaLinux 8

After the installation of PostgreSQL and adding EPEL repository, proceed to install PostGIS from the PostgreSQL added. The repository was added using command like below:

sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Enable EPEL and PowerTools repositories:

sudo dnf -y install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
sudo dnf install dnf-plugins-core
sudo dnf config-manager --set-enabled powertools

Disable default PostgreSQL AppStream repository.

sudo dnf -qy module disable postgresql

Install PostGIS for PostgreSQL 14:

sudo yum install postgis32_14

Install PostGIS for PostgreSQL 13:

sudo yum install postgis32_13

If you’re working on PostgreSQL 12, then run:

sudo yum install postgis32_12

Hit the y key to start the installation.

....
Transaction Summary
======================================================================================================================================================================================================
Install  92 Packages

Total download size: 94 M
Installed size: 404 M
Is this ok [y/N]: y

This will install PostGIS v2.5 for PostgreSQL 12.

$ rpm -qi postgis32_14
Name        : postgis32_14
Version     : 3.2.1
Release     : 1.rhel8
Architecture: x86_64
Install Date: Wed May 18 17:25:52 2022
Group       : Unspecified
Size        : 36582866
License     : GPLv2+
Signature   : DSA/SHA1, Mon Feb 14 14:03:27 2022, Key ID 1f16d2e1442df0f8
Source RPM  : postgis32_14-3.2.1-1.rhel8.src.rpm
Build Date  : Mon Feb 14 14:01:01 2022
Build Host  : koji-rhel8-x86-64-pgbuild
Relocations : (not relocatable)
Vendor      : PostgreSQL Global Development Group
URL         : https://www.postgis.net/
Summary     : Geographic Information Systems Extensions to PostgreSQL
....

Step 3: Enable PostGIS Spatial features

You need to activate PostGIS features on a database before you can
store spacial data. The example below will show you how to create a
database and activate the Spacial features.

1.Switch to postgres user.

sudo -i -u postgres

2.Create test user/database.

[postgres@rocky-linux-01 ~]$ createuser test_user
[postgres@rocky-linux-01 ~]$ createdb test_db -O test_user

3.Connect to the test database:

postgres@rocky-linux-01 ~]$ psql -d test_db
psql (14.1)
Type "help" for help.

test_db=#

4.Enable the PostGIS extension on the database:

test_db=# CREATE EXTENSION postgis;
 CREATE EXTENSION

5. Verify

test_db=# SELECT PostGIS_version();
             postgis_version            
 3.2 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
 (1 row)
test_db=# q

Refer to Official PostGIS Documentation for a usage guide and advanced configurations.

Here are installation guides for other systems.

• Install PostGIS on Ubuntu
• Install PostGIS on CentOS 7