Infrastructure at your Service

All Posts By

Karsten Lenz

Karsten Lenz

How to setup a Consul Cluster on RHEL 8, Rocky Linux 8, AlmaLinux 8 part 2

By | Database Administration & Monitoring, Postgres | 2 Comments

Within the first part I have described the setup of Consul as replacement for ETCD. Here now the setup ob keepalived, haproxy and patroni. The needed packages I have installed within the first part, so let’s start with the configuration of keepalived. At first we need to open firewalld for the VRRP Protocol: $ [[email protected] ~]# firewall-cmd –add-rich-rule=’rule protocol value=”vrrp” accept’ –permanent $ success $ [[email protected] ~]# firewall-cmd –reload $ success $ [[email protected] ~]# Next…

Read More
Karsten Lenz

Upcoming RHEL 9

By | Database Administration & Monitoring | No Comments

This Blog is about a setup of RHEL 9 BETA and changes to RHEL 8 and Fedora 34 which is the base of RHEL 9. Let’s start with the setup. Start the installation. Preview warning: Language selection: Main setup window, similar to RHEL 8, for this blog I choose the workstation setup with Office: Checking network setup, without network there will be no registration, without registration there will be no installation: Connection to Red Hat,…

Read More
Karsten Lenz

How to setup a Consul Cluster on RHEL 8, Rocky Linux 8, AlmaLinux 8 part 1

By | Database Administration & Monitoring, Operation systems, Postgres | 2 Comments

This blog describes the setup of a Consul Cluster on RHEL 8 and clones, it will be the base for a Patroni HA setup using RPM Packages from postgresql.org. Many Patroni setups are using ETCD, but ETCD is not available as RPM out of the box for RHEL 8 and clones, and in many cases using tar files or RPMS from unknown sources are not allowed. I use OS Rocky Linux 8.5 minimal installation patched…

Read More
Karsten Lenz

Migration from CentOS 8 to Rocky Linux 8

By | Database Administration & Monitoring | No Comments

This Blog describes the Migration from CentOS 8 to Rocky Linux 8. And hopefully there is a backup or VM Snapshot in place when something goes wrong. At first Updating CentOS 8 to the latest is required, but this is now not so easy, most Repositiory Mirrors are deprecated. As Preparation an adaptation of the CentOS Repo files is needed to get this task done. In this case the following repo files where in place,…

Read More
Karsten Lenz

Updating Password in PostgreSQL from md5 to scram-sha-256

By | Database Administration & Monitoring, Postgres | No Comments

Many installations have a history of many major PostgreSQL releases. With PostgreSQL 10 comes scram-sha-256 for hashing passwords, by installing from packages scram-sha-256 is the default setting for new installations since PostgreSQL 13. With this small blog I will describe how to update password from md5 to scram-sha-256. For the installation of PostgreSQL there are many blogs at dbi or articles from dbi. Blog at dbi-services.com Article at heise.de So I will not repeat this…

Read More
Karsten Lenz

PostgreSQL on ARM using Odroid N2/N2+

By | Database Administration & Monitoring | No Comments

For this installation i’m using a Hardkernel Odroid N2/N2+ which are ARM S922X, means ARM Big Little Architecture with Quad-Core-ARM-Cortex-A73-CPU-Cluster and a Dual-Core-Cortex-A53-Cluster and a Mali-G52-GPU. These device is normaly a good device as Mediaplayer using Coreelec based on Kodi, it has everything needed for including IR receiver for IR remote device. The installation of ARMBIAN is a easy step, Odroid N2 devices using a EMMC Module and with a Adapter for SD Cards it…

Read More
Karsten Lenz

PostgreSQL Flexible Server on Azure, Status

By | Database management, Development & Performance, Postgres | No Comments

This Blog is about the actual status of the development on Microsoft’s side for the Azure Flexible Server for PostgreSQL. The Flexible Server is announced “GA Ready” at November 30st, after shiftig the GA Raeady date several times. But there are still some open requirements which are “Post GA”. 1. AD Integration => Post GA, promissed Q2 2022. 2. Customer managed Keys => Post GA, promissed Q2 2022. According to the latency of 6 month…

Read More
Karsten Lenz

PostgreSQL Flexible Server on Azure, scram-sha-256 workaround

By | Cloud, Database Administration & Monitoring, Postgres | No Comments

Microsofts old Single Server for PostgreSQL on Azure offers password encryption md5 only, normaly IT Governance responsible people getting nervous by that. On the new Flexible Server for PostgreSQL on AZure md5 is still the default setting, but a workaround makes scram-sha-256 posssible to use. Since PostgreSQL 10 it is possible to switch from md5 to scram-sha-256, by using community packages scram-sha-256 is the default setting since PostgreSQL 13. Within this small block i will…

Read More
Karsten Lenz

Setup pgpass for replication

By | Database Administration & Monitoring | No Comments

This script provides functionality to setup passwordless authentication in PostgreSQL for defined Server Names. This is very helpful by using replication via repmgr and is not Linux Distribution specific, it was used till now with SLES 12, SLES 15 and RHEL 8 Clones. As all of my scripts it provides help how the usage is with -h parameter: $ [[[email protected] ~]$ sh pgpass.sh -h $ [[[email protected] ~]$ Usage: $ [[[email protected] ~]$ pgpass.sh [OPTION] $ [[[email protected]

Read More
Karsten Lenz

Recurring PostgreSQL Installations using RHEL 8 and Clones

By | Database Administration & Monitoring | No Comments

This Blog is a follow up uf one of my older Blogs and my Article at heise.de: Blog at dbi-services.com Article at heise.de For RHEL 8 at its clones like AlmaLinux, CentOS, Oracle Linux and Rocky Linux i have written a shell script to automated recurring setups. This is used for a cloud project using own virtual machines. The script automates the steps i have described at my article at heise.de. The script has an…

Read More