Patroni is a cluster manager used to customize and automate deployment and maintenance of PostgreSQL HA (High Availability) clusters. It uses distributed configuration stores like etcd, Consul, ZooKeeper or Kubernetes for maximum accessibility. In this tutorial, we will be using a single local etcd instance and two local Patroni instances on a single host instead […]

Large companies and professional business have to make sure that data is kept secure. It is necessary to defend against internal, as well as external threats. PostgreSQL provides all the necessities a company needs to protect data and to ensure that people can only access what they are supposed to see. One way to protect […]

As you all may know, our main blog is a very appreciable source for various PostgreSQL-relevant guides and tips. Our PostgreSQL experts publish content about different topics – e.g. Patroni, advanced PostgreSQL features, configuration settings, security, etc. All of those posts have one thing in common: they are data- or database-centric. That’s why, that’s the […]

(This article and the extension pg_cgroups was written for cgroups v1. The extension won’t work with cgroups v2, but the rest is still useful information.) In another blog post, I described how Linux control groups work and how they are useful for PostgreSQL. Here I will present my little PostgreSQL plugin pg_cgroups which makes this […]

Are you running PostgreSQL databases or plan to do so? Have you thought about disaster recovery? What happens if your database crashes or – more likely – the (virtual) server it runs on stops working? The best option is probably a copy of your database, that is able to take over operations, as soon as […]

  We all know that in PostgreSQL we cannot drop an object if there are view dependencies on it: Some people like it because it keeps the database consistent; some people hate it because it makes schema modifications more difficult. But that’s the way it is. In this article I want to explore the mechanics […]

Upgrade to a new major version of PostgreSQL, by Kaarel Moppel – Soon it’s that time of the year again – basically a 2nd Christmas for followers of the “blue elephant cult” if you will :). I’m, of course, referring to the upcoming release of the next PostgreSQL major version, v12. So I thought it’s […]

In my previous post about pgBackRest, we saw how to install and setup pgBackRest and make a backup of a PostgreSQL database with it. It was a very basic single server setup,  only intended to get the hang of the tool. Such setups are not used in a production environment, as it is not recommended […]

BY Kaarel Moppel – In order to prepare for the start of training season (you can see our “stock” training offerings here by the way), I’ve updated our small “Postgres features showcase” project, and thought I’d echo it out too. Main changes – coverage on some features of the current v11 release and also from […]