The Dominant Programmer
The Dominant Programmer
Mar 14, 2021 · Databases

How to Create a PostGIS Spatial Database and Import Shapefile Data

After installing PostgreSQL on Windows, this guide shows how to add the PostGIS extension via pgAdmin, create a new spatial database, verify the installation, and then use the PostGIS Shapefile and DBF Loader Exporter to import a shapefile (with accompanying DBF), handling encoding and path issues, and finally view the imported data.

GIS importPostGISPostgreSQL
0 likes · 4 min read
How to Create a PostGIS Spatial Database and Import Shapefile Data
Architects Research Society
Architects Research Society
Jan 22, 2020 · Databases

How to Install PostgreSQL 12 on CentOS 7 and CentOS 8

This step‑by‑step guide explains how to add the PostgreSQL Yum repository, install PostgreSQL 12 client and server packages, initialize and start the database service, set the admin password, optionally enable remote access, and install the pgAdmin 4 web interface on CentOS 7 or 8 systems.

CentOSDatabaseInstallation
0 likes · 11 min read
How to Install PostgreSQL 12 on CentOS 7 and CentOS 8