BE SHARING

PostgreSQL

Microsoft Flexible Server Compute V5

17.03.2023 by Karsten Lenz

Today I had the chance to move forwar with performance testing and some checks on two Flexible Server – Azure Database for PostgreSQL, one with 8vCPU, 64GB RAM and 512GB Storage (2300 IOPs) and another one with the same vCPU(…)

Database management

Flexible Server for PostgreSQL, Status March 2023

02.03.2023 by Karsten Lenz

As many know about a year ago I wrote some critical posts about Microsofts Flexible Server for PostgreSQL, now it is time to take a look again. At first, many promised functions where delivered with a latency of about one(…)

Database Administration & Monitoring

TimescaleDB

15.02.2023 by Joël Cattin

Introduction TimescaleDB is a “time-series” database (TSDB). This kind of databases are optimized for storing, manipulating and querying time-series data. But… what is time-series data ?Time-series data is a collection of metrics (regular) or measurements (irregular)(…)

Enterprise content management

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