2ndQuadrant is now part of EDB

Bringing together some of the world's top PostgreSQL experts.

2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • EN
    • FR
    • IT
    • ES
    • DE
    • PT
  • Support & Services
    • Support
      • 24/7 PostgreSQL Support
      • Developer Support
    • DBA Services
      • Remote DBA
      • Database Monitoring
    • Consulting Services
      • Health Check
      • Performance Tuning
      • Database Security Audit
      • PostgreSQL Upgrade
    • Migration Services
      • Migrate to PostgreSQL
      • Migration Assessment
  • Products
    • Postgres-BDR ®
    • PostgreSQL High Availability
    • Kubernetes Operators for BDR & PostgreSQL
    • Managed PostgreSQL in the Cloud
    • Installers
      • Postgres Installer
      • 2UDA
    • 2ndQPostgres
    • pglogical
    • Barman
    • repmgr
    • OmniDB
    • SQL Firewall
    • Postgres-XL
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA – Unified Data Analytics
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
  • Postgres Learning Center
    • Webinars
      • Upcoming Webinars
      • Webinar Library
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices for PostgreSQL
    • Blog
    • Training
      • Course Catalogue
    • Case Studies
      • Performance Tuning
        • BenchPrep
        • tastyworks
      • Distributed Clusters
        • ClickUp
        • European Space Agency (ESA)
        • Telefónica del Sur
        • Animal Logic
      • Database Administration
        • Agilis Systems
      • Professional Training
        • Met Office
        • London & Partners
      • Database Upgrades
        • Alfred Wegener Institute (AWI)
      • Database Migration
        • International Game Technology (IGT)
        • Healthcare Software Solutions (HSS)
        • Navionics
    • Books
      • PostgreSQL 11 Administration Cookbook
      • PostgreSQL 10 Administration Cookbook
      • PostgreSQL High Availability Cookbook – 2nd Edition
      • PostgreSQL 9 Administration Cookbook – 3rd Edition
      • PostgreSQL Server Programming Cookbook – 2nd Edition
      • PostgreSQL 9 Cookbook – Chinese Edition
    • Videos
    • Events
    • PostgreSQL
      • PostgreSQL – History
      • Who uses PostgreSQL?
      • PostgreSQL FAQ
      • PostgreSQL vs MySQL
      • The Business Case for PostgreSQL
      • Security Information
      • Documentation
  • About Us
    • About 2ndQuadrant
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
You are here: Home1 / Products2 / pglogical

pglogical

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.

pglogical allows you to connect PostgreSQL with other data sources and targets by creating a pluggable architecture for non-PostgreSQL subscribers and providers. Kafka and RabbitMQ are already supported with many more in the pipeline.

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.

pglogical provides the ability of failover to a physical standby, thereby ensuring minimum downtime by adding all the data present in the new primary, rather than a subset.

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.

pglogical has the ability to specify the root table and replicates all partitions through seamless integration of partitioned tables with different configuration options. Partitioning support is elastic and provides complete transparency.

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.

pglogical allows selective filtering of rows and/or columns during replication to a standby database leading to reduced traffic along with required data segregation.

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.

Availability

pglogical 2.3.3 released – October 5, 2020

pglogical is available for PostgreSQL 9.4 – 13. 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.

Complete documentation is available here.

Release notes are available here.

You can also access github repository.

pglogical is fully open source, released under the PostgreSQL licence with copyright novated to the PostgreSQL Development Group.

pglogical Knowledge Base

Videos

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.

Watch Recording

Webinar: BDR – Latest Features & Updates

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.

Watch Recording

Webinar: pglogical and Postgres BDR update

This webinar was held on 8 January 2019 and covered the following topics: Latest on pglogical and Postgres-BDR, Overview of existing features, Updates on new features, Roadmap.

Watch Recording

Webinar: Introduction to Postgres-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.

Watch Recording

Blogs

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

Read more

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

Read more

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

Read more
View All Blogs

Get in touch with us!

Please fill in the form below and we'll be in touch as soon as possible.

Support & Services

24/7 Production Support

Developer Support

Remote DBA for PostgreSQL

PostgreSQL Database Monitoring

PostgreSQL Health Check

PostgreSQL Performance Tuning

Database Security Audit

Upgrade PostgreSQL

PostgreSQL Migration Assessment

Migrate from Oracle to PostgreSQL

Products

HA Postgres Clusters

Postgres-BDR®

2ndQPostgres

pglogical

repmgr

Barman

Postgres Cloud Manager

SQL Firewall

Postgres-XL

OmniDB

Postgres Installer

2UDA

Postgres Learning Center

Introducing Postgres

Blog

Webinars

Books

Videos

Training

Case Studies

Events

About Us

About 2ndQuadrant

What does 2ndQuadrant Mean?

News

Careers 

Team Profile

© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Scroll to top
×