This is the second installment of a two-part series on 2ndQuadrant’s repmgr, an open-source high-availability tool for PostgreSQL. In the first part, we set up a three-node PostgreSQL 12 cluster...
With applications evolving over time, there’s a need to enhance and evolve database schema as well. Sometimes this process involves some database tables and columns, creating new constraints and indexes...
PostgreSQL supports many procedural languages, which can be used to write user defined functions or stored procedures. There are four that are readily available as part of the standard PostgreSQL...
I am very excited to announce the first release of " Cloud Native BDR Operator" for Kubernetes. BDR Operator is the first 2ndQuadrant product to be launched in the Cloud...
This article gives a step by step guide to utilizing Machine Learning capabilities with 2UDA. In the article, we’ll use an example of Animals to predict whether they are mammals...
As a PostgreSQL developer, I occasionally need to make my code work on Windows. As I don’t normally use Windows and don’t have a permanent Windows installation around, this has...
Preamble How many current Barman users have thought about saving backups in a remote destination in the cloud? How many have thought about taking that backup directly from the PostgreSQL...
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...
![Webinar: Application Schema Migration [Follow Up]](/sites/default/files/styles/blog_image/public/blog_posts_images/Application-Schema-Webinar-Social.png?h=ce5fe46c&itok=98jKDoft "Webinar: Application Schema Migration [Follow Up]")
