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(…)
Database Administration & Monitoring, PostgreSQL How to setup a Consul Cluster on RHEL 8, Rocky Linux 8, AlmaLinux 8 part 2 02.05.2022 by Open source Team 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(…)
Database Administration & Monitoring, PostgreSQL PostgreSQL 15: Some new features 12.04.2022 by Open source Team 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(…)
Database Administration & Monitoring, Operating systems, PostgreSQL How to setup a Consul Cluster on RHEL 8, Rocky Linux 8, AlmaLinux 8 part 1 04.03.2022 by Open source Team 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(…)
Database Administration & Monitoring, PostgreSQL Updating Password in PostgreSQL from md5 to scram-sha-256 31.01.2022 by Open source Team 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(…)
Cloud, Database Administration & Monitoring, MariaDB, MySQL, Oracle What I really like about Percona PMM 14.01.2022 by Elisa Usai Percona Monitoring and Management tool (PMM) is an Open Source product which was developed to help DBAs and developers to monitor and manage MySQL, PostgreSQL and MongoDB performances. In this blog post, we will see that we(…)