Over the next couple of months, I will be migrating the tutorials from https://andrewsarver.com over to https://sudo.how, a new site I have created for my own documentation and tutorials.
https://sudo.how will be a collection of DevOps / SysAdmin Tutorials, Tips, and Hacks.
I will do my best to have 301 redirects to all existing posts on the new site.
Thanks,
Andrew
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)
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 gisdbCreate the states table
Install PostgreSQL 12
Install and enable EPEL and PowerTools repositories if not already enabled.
Install PostGIS for PostgreSQL 12:
# dnf -y install postgis30_12Read more Install PostGIS 3.0 on CentOS 8 with PostgreSQL 12
Install the EPEL Repo
# dnf install epel-release -yInstall the Xfce group
# dnf groupinstall Xfce -yDownload 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.rpmDisable the built-in PostgreSQL module:
# dnf -qy module disable postgresqlInstall PostgreSQL:
# dnf install -y postgresql12-serverOptionally initialize the database and enable automatic start:
# /usr/pgsql-12/bin/postgresql-12-setup initdb
# systemctl enable postgresql-12
# systemctl start postgresql-12If you don’t have a tastyworks account, you may create one at tastyworks.
Download the latest RPM version of tastyworks from https://tastyworks.com/technology.
# wget https://download.tastyworks.com/desktop-1.x.x/1.8.0/tastyworks-1.8.0-1.x86_64.rpmInstall the downloaded RPM file.
# dnf localinstall tastyworks-1.8.0-1.x86_64.rpm
Login as root
Install the workstation group, change the default target to graphical, and reboot.
# dnf groupinstall workstation
# systemctl set-default graphical.target
# reboot
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.
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-develFrom 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
Recent Comments