pglogical Archives - 2ndQuadrant

Posts

PG Phriday: 10 Things Postgres Could Improve – Part 2

June 19, 2020/0 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

Last week, we examined Postgres XID wraparound complications in greater depth to see exactly how easily they can surprise even prepared enterprises. But we also found the real problem areas and how to mitigate them specifically. In this continuing series to plumb the depths of Postgres constructively, we’re going to focus on some of the […]

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

Webinar: pglogical and Postgres-BDR Update [Follow Up]

January 8, 2019/0 Comments/in 2ndQuadrant, Liaqat's PlanetPostgreSQL /by Liaqat Andrabi

Since the release of v3, Postgres-BDR has evolved into the go-to clustering technology built specially for businesses that require geographically distributed databases with multiple masters. To get an update on Postgres-BDR’s development, new features, and future roadmap, 2ndQuadrant held the pglogical and Postgres-BDR Update webinar as part of its PostgreSQL webinar series. The webinar was […]

PG Phriday: BDR Around the Globe

May 4, 2018/2 Comments/in Shaun's PlanetPostgreSQL /by Shaun Thomas

With the addition of logical replication in Postgres 10, it’s natural to ask “what’s next”? Though not directly supported yet, would it be possible to subscribe two Postgres 10 nodes to each other? What kind of future would that be, and what kind of scenarios would be ideal for such an arrangement? As it turns […]

Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part II)

April 30, 2018/0 Comments/in 2ndQuadrant, DevOps, Featured, Gulcin's PlanetPostgreSQL, pglogical, PostgreSQL /by Gulcin Yildirim

I’ve started to write about the tool (pglupgrade) that I developed to perform near-zero downtime automated upgrades of PostgreSQL clusters. In this post, I’ll be talking about the tool and discuss its design details. You can check the first part of the series here: Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I). The tool is […]

Near-Zero Downtime Automated Upgrades of PostgreSQL Clusters in Cloud (Part I)

March 23, 2018/5 Comments/in 2ndQuadrant, DevOps, Featured, Gulcin's PlanetPostgreSQL, pglogical, PostgreSQL /by Gulcin Yildirim

Last week, I was at Nordic PGDay 2018 and I had quite a few conversations about the tool that I wrote, namely pglupgrade, to automate PostgreSQL major version upgrades in a replication cluster setup. I was quite happy that it has been heard and some other people in different communities giving talks at meetups and other […]

pglogical 2.1 and Logical Replication in PostgreSQL 10

December 13, 2017/10 Comments/in Petr's PlanetPostgreSQL /by Petr Jelinek

One of the headline features of the brand new PostgreSQL release out 2 months ago is Logical Replication. Logical replication allows more flexibility than physical replication, including replication between different major versions of PostgreSQL and selective-table replication. You can get more details on the feature here. So, now that we have this, I’ve been asked […]

PG Phriday: pglogical and Postgres 10 Partitions

September 22, 2017/5 Comments/in pglogical, Shaun's PlanetPostgreSQL /by Shaun Thomas

During the Postgres Open 2017 conference in San Francisco, someone came to the 2ndQuadrant booth and struck up a conversation with me. During our shameless geeking out over database mechanics, he asked me if pglogical supported the new Postgres 10 partitions. Given my noted expertise in all things Postgres, I answered in the appropriate manner: […]

Logical Replication in PostgreSQL 10

April 28, 2017/33 Comments/in Petr's PlanetPostgreSQL /by Petr Jelinek

PostgreSQL 10 is getting close to its first beta release and it will include the initial support for logical replication, which is was written primarily by me and committed by my colleague Peter Eisentraut, and is internally based on the work 2ndQuadrant did on pglogical (even though the user interface is somewhat different). I’d like […]

Re-import repository keys for BDR and pglogical apt repositories

March 23, 2017/2 Comments/in Craig's PlanetPostgreSQL /by craig.ringer

The BDR and pglogical apt repository GnuPG signing keys have been renewed. Users should re-import the existing keys. You can verify that it’s still the same key as referenced in the documentation, just with a later expiry date. Simply run: wget –quiet -O – http://packages.2ndquadrant.com/bdr/apt/AA7A6805.asc | sudo apt-key add – sudo apt-key finger AA7A6805 | […]

Posts

PG Phriday: 10 Things Postgres Could Improve – Part 2

Failover slots for PostgreSQL

Webinar: pglogical and Postgres-BDR Update [Follow Up]

PG Phriday: BDR Around the Globe

pglogical 2.1 and Logical Replication in PostgreSQL 10

PG Phriday: pglogical and Postgres 10 Partitions

Logical Replication in PostgreSQL 10

Re-import repository keys for BDR and pglogical apt repositories

Support & Services

Products

Postgres Learning Center

About Us