high availability Archives - 2ndQuadrant

Posts

Webinar: Enhancing Postgres High Availability [Follow Up]

July 16, 2020/0 Comments/in Webinars /by Adnan Nazar

Postgres High Availability is not just about putting together the right pieces. We should also consider the following: Why did we choose those components? What can go wrong? How do we prevent edge cases from ruining our day? Can we possibly build a cluster that is “Always On” in the face of Network Partitions, Split […]

Failover slots for PostgreSQL

June 8, 2020/0 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

Logical decoding and logical replication is getting more attention in the PostgreSQL world. This means we need it working well alongside production HA systems – and it turns out there’s a problem there. Replication slots are not themselves synced to physical replicas so you can’t continue to use a slot after a master failure results […]

How to deploy a multi-master BDR cluster in Kubernetes

June 8, 2020/0 Comments/in Cloud Native /by Gabriele Bartolini

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 BDR Operator and […]

Automated rapid switchover with a BDR database cluster in Kubernetes

April 21, 2020/0 Comments/in Cloud Native /by Gabriele Bartolini

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 […]

Business Continuity at 2ndQuadrant – How We Remain Effective in Emergencies

March 10, 2020/0 Comments/in 2ndQuadrant, Business, Featured /by Umair Shahid

Ensuring high availability for our clients’ PostgreSQL databases is our primary business objective. We are able to achieve that by ensuring availability of our PostgreSQL experts round the clock and around the world. Just like we plan failover and switchover contingencies for our clients, we plan for backups and backups-of-backups for business continuity so our […]

Replication configuration changes in PostgreSQL 12

October 7, 2019/0 Comments/in Ian's PlanetPostgreSQL, repmgr /by Ian Barwick

Historically, PostgreSQL’s replication configuration has been managed via a configuration parameters stored in a dedicated configuration file, recovery.conf, which has been present in PostgreSQL since the introduction of archive recovery in PostgreSQL 8.0. One of the major changes in PostgreSQL 12, co-authored by 2ndQuadrant is the replacement of recovery.conf and the conversion of recovery.conf parameters […]

PG Phriday: PgBouncer or Bust

January 11, 2019/4 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

What is the role of PgBouncer in a Postgres High Availability stack? What even is PgBouncer at the end of the day? Is it a glorified traffic cop, or an integral component critical to the long-term survival of a Postgres deployment? When we talk about Postgres High Availability, a lot of terms might spring to […]

Oracle High Availability concepts in PostgreSQL

October 26, 2017/11 Comments/in 2ndQuadrant, Barman, PostgreSQL, Simon's PlanetPostgreSQL /by Simon Riggs

Sometimes people ask about certain Oracle High Availability features and whether they exist in PostgreSQL. In most cases, very similar features exist. The reason for the similarity is that PostgreSQL and Oracle have very similar architectures and so the mechanisms to protect data have also developed along the same lines. For example, Oracle Data Guard […]

repmgr 3.2 is here with Barman support and Brand New High Availability features

October 10, 2016/0 Comments/in Ian's PlanetPostgreSQL, repmgr /by Ian Barwick

repmgr 3.2 has recently been released with a number of enhancements, particularly support for 2ndQuadrant’s Barman archive management server, additional cluster monitoring functionality and improvements to the standby cloning process. One aim of this release is to remove the requirement to set up passwordless SSH between servers, which means when using repmgr’s standard functionality to […]

Read 2ndQuadrant’s response to the COVID – 19 emergency here

Posts

Webinar: Enhancing Postgres High Availability [Follow Up]

Failover slots for PostgreSQL

Business Continuity at 2ndQuadrant – How We Remain Effective in Emergencies

Replication configuration changes in PostgreSQL 12

PG Phriday: PgBouncer or Bust

Oracle High Availability concepts in PostgreSQL

repmgr 3.2 is here with Barman support and Brand New High Availability features

Support & Services

Products

Postgres Learning Center

About Us