BE SHARING

PostgreSQL

A generic jdbc tester (part I)

27.01.2023 by Cesare Cervini

A generic utility to test JDBC connections to any RDBMS or no SQL data source whose JDBC drivers are provided. Listing, PostgreSQL, Oracle Thin.

Database Administration & Monitoring

How to submit a talk for a conference

23.01.2023 by Julia Gugel

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

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

Fast setup of a two node repmgr cluster with auto failover

23.12.2022 by Karsten Lenz

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

Recreate a Patroni replica using pgBackRest

17.11.2022 by Julia Gugel

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 Julia Gugel

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

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

Setup a PostgreSQL Instance in Google Cloud SQL

24.10.2022 by Julia Gugel

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 Cluster using repmgr

11.08.2022 by Karsten Lenz

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(…)

Operation systems

PostgreSQL on 80 core ARM Server

25.07.2022 by Karsten Lenz

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(…)