The next generation of logical replication for PostgreSQL
pglogical is a logical replication system implemented entirely as a PostgreSQL extension. Fully integrated, it requires no triggers or external programs. This alternative to physical replication is a highly efficient method of replicating data using a publish/subscribe model for selective replication.
pglogical forms the foundation for BDR – which runs as an extension on top of it – providing the essential logical replication and other technologies for its features.
Connect PostgreSQL with other data sources and targets
The 3rd generation of pglogical separates out the receiver and writer processes, creating a pluggable architecture for non-PostgreSQL subscribers & providers. pglogical already supports Kafka and RabbitMQ, with many more in the pipeline.
Minimize downtime with physical failover
pglogical has the ability to failover to a physical standby, thereby ensuring that all standby databases in the cluster remain available as standbys to the new primary. A physical failover ensures that all data is present in the new primary, rather than a subset – as opposed to failing over to a logical standby, which does not guarantee the entire dataset.
Seamlessly replicate new and updated data structures
With Transparent DDL Replication, pglogical provides seamless replication for any updates to the data structure of the source database. The DDL replication is statement-based, i.e. it is the statement that is replicated, not the result.
Transparent partitioning support
Through seamless integration of partitioned tables, pglogical allows you to specify the root table and replicates all partitions. Different partitioning configurations can be defined on the subscriber, including replication of a non-partitioned table to a partitioned one, and vice versa. Partitioning support is elastic, allowing to add and remove partitions transparently.
Row and column filters
Taking advantage of logical replication, pglogical allows to filter rows and/or columns that need to be replicated to the standby database. Being selective during replication allows for reduced traffic, as well as data segregation as needed.
pglogical 2.3.2 released – May 29, 2020
pglogical is available for PostgreSQL 9.4 – 12. It is available via 2ndQuadrant’s apt and yum repositories for Debian and Red Hat family (RHEL, CentOS, and Fedora). You can use standard apt and yum package managers for installing pglogical with your instance of PostgreSQL.
Detailed installation instructions are available here.
pglogical is fully open source, released under the PostgreSQL licence with copyright novated to the PostgreSQL Development Group.
pglogical Knowledge Base
Webinar: Cloud Native BDR and PostgreSQL
Are you looking forward to using BDR and PostgreSQL in a Cloud Native environment based on Kubernetes? This webinar is the perfect opportunity for you to see where Cloud-Native BDR and Cloud-Native PostgreSQL products developed by 2ndQuadrant stand and how they can be integrated in your Kubernetes workloads.
This webinar was held on 15 January 2020 and covered the following topics: Introduction to BDR (Bi-Directional Replication) and BDR fundamentals, BDR Architecture and latest features available in BDR, AlwaysOn – Advanced high availability and rolling upgrades, Disaster Recovery, Latency and Worldwide Clusters with BDR, Latest use-cases for BDR and Making applications compliant with BDR.
This webinar was held on 16 May 2018 and covered the following topics: Introduction to Postgres-BDR, Postgres-BDR Architecture, High Availability, Disaster Recovery, Rolling Upgrades, Latency and Geographical Distribution with Postgres-BDR, Common use cases for Postgres-BDR and Making applications compliant with Postgres-BDR.
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 […]
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 […]
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 […]