The latest Barman 2.10 release introduces support for the system identifier of a PostgreSQL instance. In this article, I will answer a few questions explaining what a system identifier is...
This is a story about how I found myself trying programming languages. I’ve been running an OLTP type database test ( DBT-2, if you’ve heard of it), and noticed the...
Human oversight is one of the many reasons for compromising a database. Disasters happen, but having a solid backup and disaster recovery plan in place can help your business mitigate...
Being a PostgreSQL database administrator and managing backups on a daily basis, one of the new features of Barman 2.10 that I liked the most is the transparent management of...
Securing data in motion is a necessity in today’s world. PostgreSQL provides a way to encrypt and authenticate communication by using a Secure Sockets Layer or SSL protocol. 2ndQuadrant hosted...
In the past year, I have had conversations with many clients and prospects about Postgres-BDR. Postgres-BDR has been in production for many mission critical deployments for quite some time. We...
I have written about managing a PostgreSQL commitfest before. During the PostgreSQL 13 development cycle, I did it again. This time I used a different strategy, mostly because I felt...
Now that PostgreSQL 12 is out, we consider foreign keys to be fully compatible with partitioned tables. You can have a partitioned table on either side of a foreign key...
