Recently there were some complaints about the behaviour of the jsonb_set function. Specifically, the complain was that if the value argument of the function is null the result is null...
BDR is a rapidly evolving project — and has been generating great interest from the Postgres community. In order to give further insights into BDR, how it works and where...
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...