My DBA Notebook

I always heard that once you had performed either a switchover or a failover, you needed to create a fresh backup of your Postgres cluster.

This post is part of several blog posts (at least two!)

[2020-03-22 Edit: I got several tips from friends showing me better ways to test if Postgres was running that I decided to edit this post to make it better.

TLDR: If you use an up-to-date kernel or up-to-date Postgres (last minor version for a supported version), you’ll be safe.

Single Sign-On (SSO) is a great security feature because if users don’t have to create many accounts and manage several passwords, they will agree on using a complex password more easily (or at least, we hope they do).

Since I’m a consultant, I frequently (well, kind of always, actually) run into customers with bad managed PostgreSQL configuration file.

Transaction isolation is often misunderstood of even not known at all.

When I published on Twitter that my first code patch (you know, the one about hyperbolic functions) was pushed into Postgres core and that it will be shipped in Postgres 12, I was surprised by an answer.

Imagine that moment: you’ve written your first patch for Postgres, the community said it’s a good idea and there’s no major problem with it.

When you set your instance to allow replication type connection with a user, it happens that sometimes you’d like to test that connection with your user.

Markus Winand is an SQL expert, a real one who’s not afraid reading the SQL norm.

When you (or someone else) add new features to Postgres, we need to be sure we didn’t break anything… That’s where regression tests are quite handy.

I won’t explain here how to clone the PostgreSQL repository.

Patroni is a high availability solution for PostgreSQL.

If you were involved in PostgreSQL in 2017 and 2018, you should have heard about Zheap.

Creating a documentation patch is not easier than writing a code patch.

I’m pretty excited because I’m writing a patch that will add functions to PostgreSQL, so I’m hacking into Postgres.