Getting Started with PostGIS – Import Shapefiles (SHP Files)

You will need a PostgreSQL server with PostGIS extensions enabled on a database.

Find some data you want to plot. A good free resource is https://hub.arcgis.com/

In this tutorial, we will use Internet Towers in Parkland County, Alberta, Canada. https://hub.arcgis.com/datasets/tempegov::accessible-service-providers

Read more Getting Started with PostGIS – Import Shapefiles (SHP Files)

Install PostgreSQL on CentOS 8

Download and install the latest repo RPM from https://yum.postgresql.org/

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

Disable the built-in PostgreSQL module:

# dnf -qy module disable postgresql

Install PostgreSQL:

# dnf install -y postgresql12-server

Optionally initialize the database and enable automatic start:

# /usr/pgsql-12/bin/postgresql-12-setup initdb
# systemctl enable postgresql-12
# systemctl start postgresql-12