Si les gusta trabajar con el particionamiento declarativo de PostgreSQL, puede que se pregunten cómo comprobar en qué partición se encuentra un registro específico. Aunque la respuesta es bastante obvia en los casos del particionamiento de lista o de rango, con el particionamiento hash resulta un poco más complicado. De todas formas, no hay por qué preocuparse. Un método muy rápido para saber en...

If you are enjoying working with PostgreSQL declarative partitioning, you might be wondering how to check which partition contains a specific record. While it is quite obvious in the cases of list or range partitioning, it is a bit trickier with hash partitioning. Don’t worry. Here you can find a quick way to determine which partition contains a given row, by simply taking advantage of PostgreSQL...

Cloud Native PostgreSQL and Cloud Native BDR are the two Kubernetes operators written by 2ndQuadrant entirely from scratch in the Go language and relying exclusively on the Kubernetes API. The reason behind this choice stands on an important 3-word concept: Immutable Application Containers. Our operators for PostgreSQL and BDR are currently private products available only under Production Support...

Can I use PostgreSQL in Kubernetes and expect to achieve performance results of the storage that are comparable to traditional installations on bare metal or VMs? In this article I go through the benchmarks we did in our own Private Cloud based on Kubernetes 1.17 to test the performance of local persistent volumes using OpenEBS Local PV. I have been working with databases for more than 20 years...

Discover in this article and video how BDR can be easily and quickly deployed on Kubernetes thanks to our Cloud Native BDR Operator. BDR is a full mesh replication solution for PostgreSQL databases developed by 2ndQuadrant that provides both high availability and multi-master capabilities. It is now available for Kubernetes on Public and Private environments, thanks to 2ndQuadrant’s Cloud Native...

PostgreSQL 13 introduces two useful features to enhance automated validation of physical backups: backup manifests and a new tool called pg_verifybackup. In this short article I attempt to provide an overview of them. As you probably know if you are familiar with PostgreSQL and the PostgreSQL Community, I have been promoting business continuity and disaster recovery awareness in organisations for...

Discover how BDR and Kubernetes allow you to reach very high uptimes in a year for a database solution thanks to the fast failover capability. Watch the demo! In my previous article we went through the deployment of a BDR database in a Kubernetes cluster using our Cloud Native BDR Operator, and in particular we focused on declarative configuration and multi-master capability. We demonstrated how...

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 Native landscape and it is part of our long term commitment in this area: 2ndQuadrant indeed is a Silver member of the Cloud Native Computing Foundation and, most importantly, a Kubernetes Certified Service Provider. BDR Operator...

Barman 2.6 introduces support for geo-redundancy, meaning that Barman can now copy from another Barman instance, not just a PostgreSQL database. Geographic redundancy (or simply geo-redundancy) is a property of a system that replicates data from one site (primary) to a geographically distant location as redundancy, in case the primary system becomes inaccessible or is lost. From version 2.6, it is...

Today our Devops team at 2ndQuadrant, led by my dear friend and trusted colleague Marco Nenciarini, released version 2.3 of Barman. The main news is that this release has been thoroughly tested to work on the upcoming PostgreSQL 10. This major release of PostgreSQL has completely changed naming conventions for one of the most important concepts of crash recovery and replication: the WAL file. So...