PostgreSQL

PostgreSQL client only installations from source code

During our PostgreSQL DBA Essentials workshops we install PostgreSQL from source code. We do that, to provide the participants all the options they have. There is nothing wrong with using a packaged distribution of PostgreSQL, don't get(…)

PostgreSQL 15: Add row filters for logical replication

My last post about logical replication in PostgreSQL was in 2017 before PostgreSQL 10 was released later that year. There have been many enhancements to logical replication since then and today we'll look at a new features(…)

PostgreSQL 15: New option for NULL handling in unique constraints

Another nice feature was just committed for PostgreSQL 15: Add UNIQUE null treatment option (discussion here, commit details here). What is it about? The answer is quite easy if we do a little example(…)

PostgreSQL 15: New function to list flags associated to GUCs

As development of PostgreSQL 15 is on its way, more and more features get committed. Today we'll look at a new feature which is not a hammer feature, but a nice thing to have and to know about. If you(…)

New options for pg_basebackup in PostgreSQL 15

If, and you should, are doing base backups of your PostgreSQL instances you've probably used pg_basebackup. Another use case for pg_basebackup is to create a starting point for replicas when you are setting up streaming replication. Up(…)

Getting explain plans out of Db2

The last post about Db2 was about getting it up and running. As the issue we had to solve was about performance, getting an explain plan for the problematic statement(s) was the obvious step to do. In(…)

Open source monitoring solutions (2) – Zabbix agents and PostgreSQL monitoring

By the end of the last post we finished with a running Zabbix server which uses PostgreSQL as it's back-end database. In addition a Zabbix agent is running on the same host, so the monitoring host itself(…)

PostgresBuild2021 – questions feedback (1)

PostgresBuild2021 is currently ongoing and as usual, I had questions after my talk I could not immediately answer. One of the best ways to learn, is to present a topic. There are for sure questions you never(…)

Open source monitoring solutions (1) – Zabbix server setup

We are often asked which monitoring solution we recommend for PostgreSQL, by people attending our PostgreSQL workshops. We usually answer: What do you have in place already? If a solution already is in place, the most obvious(…)

Using pgBackRest to backup your PostgreSQL instances to a s3 compatible storage

When it comes to backup and restore of PostgreSQL we usually recommend pgBackRest to our customers. This tool comes with many options and features and should bring everything you need. Most of the times we install a(…)