Infrastructure at your Service

All Posts By

Karsten Lenz

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
Karsten Lenz

De-Ubuntu Ubuntu

By | Operation systems | No Comments

Canonical is consistently promoting Snap Integration in the Ubuntu world with all its market power. However, many do not like this development with Ubuntu. But what options do you still have as an Ubuntu user if you don’t necessarily want to change the distribution? I’ll show you how to run Ubuntu 20.04 with Flatpak instead of Snap and get rid of the data-collecting packages. Many switch to Linux because dealing with privacy in other operating…

Read More
Karsten Lenz

Rancher installation on RHEL 8 compatible Linux

By | Docker, Kubernetes | No Comments

This Blog is about the installation of Rancher Community on a RHEL 8 compatible Linux, for this Blog i choose AlmaLinux 8.4, but i will also work on Rocky Linux 8.4 Release Candidate. Base is an AlmaLinux / Rocky Linux minimal installation on a VMWare Host for all nodes, using the same configuration with 4vCPU and 4GB RAM. A small comaprsion of RHEL 8 and the alternatives can be found in my other blog her:…

Read More
Karsten Lenz

CentOS 8 binary compatible alternatives

By | Database Administration & Monitoring | No Comments

There is a lot of roumors around since it was anounced to switch CentOS 8 from a Downstream Build from RHEL 8 to a Upstream Build for RHEL 8 on December 8th 2020. Many people asked why a second Upstream to Fedora and the way of communication choosen was sub optimal in diplomatic words. Cutting the support date from 31st of May 2029 to 31st of December 2021 brings many people in trouble which has…

Read More
Karsten Lenz

CentOS 8 alternatives

By | Operation systems | No Comments

Many people are unhappy about the decision from the CentOS Board of Directors, to switch from fix releases to Stream and cutting the support date from 2029 to 31st of December 2021 for CentOS 8. Many applications in productive environments require fix OS releases. Having more or less daily changing packages can cause many issues. People who have upgraded from CentOS 7 to 8 are in trouble again, the cut on the support date means,…

Read More
Karsten Lenz

Microsoft Flexible Server for PostgreSQL

By | Postgres | No Comments

This Blog is about some findings on Microsoft’s new Flexible Server offering for PostgreSQL which is in Customer Preview at the moment. Findings about the infrastructure The Microsoft Flexible Server for PostgreSQL is using Ubuntu as OS infrastructure, I think it is worth to be noticed that Microsoft’s new offering is switching from Windows to Linux. postgres=> select version(); version —————————————————————————————————————– PostgreSQL 12.5 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.12) 5.4.0 20160609, 64-bit Ubuntu upgrade…

Read More
Karsten Lenz

Azure Database for PostgreSQL

By | Database Administration & Monitoring | No Comments

This Blog is about some findings on Microsoft’s Azure service for PostgreSQL which I think needed to be noted. Findings about the infrastructure The Microsoft Azure Service for PostgreSQL is using Windows as OS Infrastructure, there are several points where it is possible to find out the used OS on PostgreSQL Level. select version(); => PostgreSQL 11.6, compiled by Visual C++ build 1800, 64-bi show dynamic_shared_memory_type; => windows show archive_command; => c:\postgres\bin\xlogcopy\xlogcopy.exe archive blob “%f”…

Read More
Karsten Lenz

The log_duration parameter in PostgreSQL

By | Database Administration & Monitoring | No Comments

log_duration is a useful point for finding slow running queries and to find performance issues also on the applications side using PostgreSQL as database. Another topic is finding issues with Java Applications using Hibernate after a migration to PostgreSQL. Often Hibernate switches from lazy to eager mode and this has massive impact on the application performance. In this context I will also describe one of the most useful extensions: pg_stat_statements. The log duration shown in…

Read More