Database Administration & Monitoring

Bootstrap Patroni Cluster from pgBackRest Backup

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

2022.pgconf.eu, what a blast

2022.pgconf.eu is currently happening in Berlin. We have a record number of 600 attendees, this makes it the largest ever PostgreSQL Conference Europe and we’re hitting the hard limits of the(…)

Patching ODA HA from 19.14 to 19.16

By Mouhamadou Diaw Patching an ODA is always exciting. Preparing a patch of an ODA HA may seem more complicated that an single ODA. But it’s the same processus. All patching operations should be run on(…)

Oracle Exchange Partition

The Oracle Exchange Partition is a method allowing to : exchange the data segments from a non partitioned table to a partitioned table exchange the data segments from a partitioned table to a non partitioned table. This method(…)

Meson vs. make: PostgreSQL build and test times

In the last post we’ve looked into how you can build PostgreSQL with Meson instead of the traditional way using configure/make. The reason for this was a(…)

Building PostgreSQL with Meson

Last year, around this time, there started a thread on hackers which was about building PostgreSQL with meson. I didn’t know anything about Meson at this time, and don’t know much(…)

Oracle Database Row Archiving

In a recent customer project, I was suffering to delete millions of rows from a LOG table. Removing 3 months of data took more than 30 minutes with the best optimization possible. After a while, I remembered(…)

PostgreSQL from packages on NetBSD

The last flavor of BSD we’ll look at is NetBSD. We already had FreeBSD (here and here) and OpenBSD (here and(…)

PostgreSQL from source on OpenBSD

In the last post we’ve seen that it is quite easy to get started with PostgreSQL on OpenBSD when you install from the provided packages. The downside of this was, that not the latest version(…)

PostgreSQL from packages on OpenBSD

Almost all of our customers run PostgreSQL on one of the distributions of Linux, either installed from packages or from source code. But there is not only Linux, there a various flavors of BSD you(…)