gexec in psql: PostgreSQL poweruser practice
For PostgreSQL powerusers, automating repeated steps is becoming more and more necessary, and gexec can help. This blog will show you how to use the || operator and the \gexec command to avoid unnecessary repetition in your workflow. The CLI client that ships with PostgreSQL is called psql. Like many CLI clients, it is often […]
TLS: Demystifying communication encryption in PostgreSQL
In this post, we want to give you a brief introduction to TLS (Transport Layer Security), which is a technology widely used in combination with PostgreSQL to encrypt client / server connections. What is TLS? TLS is short for “Transport Layer Security“, which is a means of making sure that whatever data you are sending […]
Introduction and How-To: etcd clusters for Patroni
etcd is one of several solutions to a problem that is faced by many programs that run in a distributed fashion on a set of hosts, each of which may fail or need rebooting at any moment. One such program is Patroni; I’ve already written an introduction to it as well as a guide on how […]
Patroni : Setting up a highly available PostgreSQL Cluster
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 […]
PostgreSQL High-Availability and Patroni – an Introduction.
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 […]