Posts published under the Open source Team account are collective contributions by the dbi services open infrastructure consultants. The practice covers open-source databases and platforms, PostgreSQL first of all, along with MySQL, MariaDB, and Linux, from architecture, replication, and high availability to performance tuning and operations under service level agreements, and contributes actively to the PostgreSQL community.
This Blog is about a setup of a Rocky Linux Repository server. Many people whould complain that it will be the same than RHEL 8, but is is not, there are some differencies between AlmaLinux, Rocky Linux, Oracle Linux and RHEL 8. Base is a Rocky Linux Linux 8.6 minimal installation. The installation of EPEL is similar to AlmaLinux. in…
This Blog is about to setup a AlmaLinux 8 Repository Server including EPEL and RPMFusion. Many people whould complain that it will be the same than RHEL 8, but is is not, there are some differencies between AlmaLinux, Rocky Linux, Oracle Linux and RHEL 8. Base is a AlmaLinux 8.6 minimal installation. The installation of EPEL is a bit different…
As you might know, you can create temporary tables, views and sequences in PostgreSQL. Temporary means, that the temporary table, view or sequence will be dropped when you either end your session or you transaction. When the drop will happen depends on the options you used when you created the object. As all objects in PostgreSQL are stored in a…
It has been an amazing ride: 1st of May 2022 I have been with dbi services for exactly seven years. This is by far the longest employment in my career. When I started way back in 2015 most of my work was still around Oracle products, like the Oracle Database and Oracle Grid Infrastructure, Oracle GoldenGate and a bit of…
One of our long term-time customers, Helvetia, successfully migrated on-prem Oracle databases to AWS, not only because of the licenses, but more importantly: to deploy faster, innovate faster, and use the state-of-the-art open source database system. When you plan such a project, you need to know which tools you want to use and what the target architecture shall look like.…
During previous months, I’ve had some time to satisfy my curiosity about databases in containers and I started to test a little bit MySQL in Kubernetes. This is how it all began… In January I had the chance to be trained on Kubernetes attending the Docker and Kubernetes essentials Workshop of dbi services. So I decided to prepare a session…
It’s been a while since I wrote the blog post about PostgreSQL 13 and Patroni 2.0. On this blog I received a comment, if it’s possible to explain, how to upgrade from Patroni 1.6 to 2. So let’s make a short blog about the upgrade procedure of Patroni. For my initial installation is used python pip, not the rpm packages.…
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: $ [root@patroni-01 ~]# firewall-cmd –add-rich-rule=’rule protocol value=”vrrp”…
PostgreSQL version 15 is on its way and we get a better and better look, what will be included in the future release. So it’s time to have a look at some new future features 1. Create privilege on public schema removed Until today with PostgreSQL 14 it is possible for everybody to write into the public schema per default.…
Another nice feature just made it into PostgreSQL 15: You can now control who is allowed to set specific parameters. This gives you a lot more flexibility, especially when you are hosting PostgreSQL instances for your customers. You can delegate more control to trusted users or roles and of course, you can also revoke it later on when it is…
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…
During our PostgreSQL DBA Essentials workshops we install PostgreSQL from source code. We do that, to provide the participants all the options they have. There is nothing wrong with using a packaged distribution of PostgreSQL, don’t get me wrong, but knowing how it is working in the background is always a good idea. One question that comes up quite frequently…
