Database Administration & Monitoring, Database management, Operating systems, PostgreSQL Uyuni, an open-source configuration and infrastructure management solution for software-defined infrastructure (2) – Adding a client 29.12.2022 by Daniel Westermann In the last post we’ve installed and configured the Uyuni server. In this post we’ll add our first client we later on can manage through the Uyuni server. Quite some distributions are(…)
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 management, PostgreSQL, YaK 2022.pgconf.eu Berlin conference for tech 31.10.2022 by Hervé Schweitzer Last week, the biggest European PostgreSQL event of the year took place in Berlin (2022.pgconf.eu). This event is an excellent opportunity to meet developers from the PostgreSQL community and to attend high profile tech presentations. Tuesday evening we started(…)
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(…)
PostgreSQL Major PostgreSQL version upgrade in a Patroni cluster 22.06.2022 by Joël Cattin Introduction One of my customer recently asked me to upgrade its PostgreSQL instance from version 9.6 to version 14.3. The infrastructure is composed of 4 servers : – DB02-04 – Ubuntu 20.04 – supporting PostgreSQL, Patroni, HAProxy and etcd–(…)
Database Administration & Monitoring, PostgreSQL Helvetia used AWS SCT & DMS to migrate to AWS RDS for PostgreSQL 19.05.2022 by Daniel Westermann 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(…)