Database Administration & Monitoring, Database management, PostgreSQL How to submit a talk for a conference 23.01.2023 by Open source Team I already did some talks at conferences and I had already the honor to select talks for a conference. During this talk selection I found some excellent examples on how to do to a proposal, but unfortunately also some examples(…)
Database Administration & Monitoring, Database management, PostgreSQL Fast setup of a two node repmgr cluster with auto failover 23.12.2022 by Open source Team This blog is about a fast, script based, setup of a repmgr two node cluster with auto failover. This setup is very easy and the requirements comparing to a patroni setup very low, for exapmle as open port on the(…)
Database Administration & Monitoring, PostgreSQL Recreate a Patroni replica using pgBackRest 17.11.2022 by Open source Team In my last blog we had a look on how to bootstrap a complete Patroni Cluster from pgBackRest. But there is also the possibility to recreate only one Patroni node using pgBackRest. In this blog we(…)
PostgreSQL pgconf.eu 2022: Review 31.10.2022 by Open source Team Last week I had the pleasure to join the pgconf.eu in Berlin. After three years of waiting since Milan 2019, I was really excited to travel to Berlin to meet all the PostgresFriends again and of(…)
Database Administration & Monitoring Bootstrap Patroni Cluster from pgBackRest Backup 27.10.2022 by Open source Team While preparing myself for the pgconf.eu in Berlin this week I made a lot of research regarding Patroni and pgBackRest. I was aware that it’s possible to recreate a replica from a pgBackRest backup. But I was also wondering, what(…)
Cloud, Database management, PostgreSQL Setup a PostgreSQL Instance in Google Cloud SQL 24.10.2022 by Open source Team This blog will be the first of a series of blogs, to report about my experiences with Google Cloud SQL. In this blog we will setup a basic PostgreSQL instance in the Google Cloud. If you’re new to Google Cloud,(…)
Database management, PostgreSQL PostgreSQL Cluster using repmgr 11.08.2022 by Open source Team With this blog I describe the installation of a PostgreSQL Cluster using repmgr instead of Patroni. Repmgr was originally developed by 2ndQuadrant which is now part of EDB and EDB decided for the 2ndQuadrant tools for the future, barman as(…)
Operating systems, PostgreSQL, Technology Survey PostgreSQL on 80 core ARM Server 25.07.2022 by Open source Team This Blog is about intallation and testing PostgreSQL 14 latest on an ARM based 80 core Server using Rocky Linux 8.6. Many thanks to Happyware for providing the machine used for this Blog. https://happyware.com/ The machine used for this(…)
Operating systems Setup a Rocky Linux Repository server 18.07.2022 by Open source Team 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(…)
Operating systems Setup a AlmaLinux 8 Repository Server 18.07.2022 by Open source Team 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,(…)