Daniel Westermann

pg_basebackup and redirecting progress messages to a file

Recently I came over that commit and wondered what that is about. The answer is quite simple but I didn't know that this issue existed. Basically it is about how progress messages are written to screen and(…)

PostgreSQL 11: Procedures and transaction control

Up to PostgreSQL 10 it was not possible to create procedures in PostgreSQL. Of course you can create functions which do not return anything but the possibility to create a procedure was not there. That will probably change in PostgreSQL(…)

Finally you will be able to use exit and quit in psql

When giving the PostgreSQL DBA Essentials workshop one of the main issues people have is how they can exit psql. Even on stackoverflow this is a popular topic. The good news(…)

Parallel pg_dump is slow by default?

Short answer: Yes, it is. Being at a customer the last days we wanted to parallel pg_dump a 2TB database. We were quite surprised that it was quite slow and it was not immediately clear why it was. Well, the(…)

Configuring huge pages for your PostgreSQL instance, Debian version

In the last post we had a look at how you can configure huge pages on RedHat and CentOS systems. For Debian and Debian based systems the procedure is different as Debian does not come with(…)

Configuring huge pages for your PostgreSQL instance, RedHat/CentOS version

Almost every PostgreSQL I get in touch with is not configured to use huge pages, which is quite a surprise as it can give you a performance boost. Actually it is not the PostgreSQL instance you need(…)

New SHA-2 functions showing up in PostgreSQL 11

A recent commit announced new SHA-2 functions coming up in PostgreSQL 11. Until now you can use the md5 function to generate hashes for test data or whatever you want. This commit adds more(…)

My personal journey with Linux on the desktop

My Linux experience started back in 1999 when we needed a router for our ISDN connection in our shared apartment when we were students. I don't remember the hardware we used for that but I am sure at(…)

What you can do when your Veritas cluster shows interfaces as down

Recently we had the situation that the Veritas cluster (InfoScale 7.3) showed interfaces as down on the two RedHat 7.3 nodes. This e.g. can happen when you change hardware. Although all service groups were up and running this is a(…)

How we build our customized PostgreSQL Docker image

Docker becomes more and more popular these days and a lot of companies start to really use it. At one project we decided to build our own customized Docker image instead of using the official PostgreSQL one.