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)

Getting Started with PostGIS – Mapping US States

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

Download some sample data. This tutorial uses the US States.

https://www.kaggle.com/washimahmed/usa-latlong-for-state-abbreviations

As the postgres user, connect to the GIS database

$ psql -d gisdb

Create the states table

Read more Getting Started with PostGIS – Mapping US States

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

Set Up MySQL/MariaDB Master-Slave Replication

MySQL Master-Slave replication allows for data to be automatically copied to multiple computers. Changes are made to the designated “master” node and replicated to one or more designated “slave” nodes for read-only applications.

This tutorial provides step-by-step instructions for setting up a MySQL/MariaDB master-slave database configuration. CentOS 8 and MariaDB 10.5 are used in this example.

Two servers are used in this tutorial, db01 (the master node) and db02 (the slave node). If you already have a database running on the master node, you must dump and restore a backup of the database into the slave node prior to enabling replication.

Read more Set Up MySQL/MariaDB Master-Slave Replication

Install VirtualBox Additions on CentOS 8

Login as root and install packages required for building kernel modules and elfutils-libelf-devel as a prerequisite for the additions.

# dnf install gcc kernel-devel kernel-headers dkms make bzip2 perl elfutils-libelf-devel

From the VirtualBox window, insert the guest-tools CD image.
Devices -> “Insert Guest Additions CD Image”

Mount the virtual CD-ROM drive and install the VirtualBox Additions.

# mkdir /mnt/cdrom
# mount /dev/cdrom /mnt/cdrom
# cd /mnt/cdrom/
# sh ./VBoxLinuxAdditions.run --nox11
# reboot