2ndQuadrant | PostgreSQL
Mission Critical Databases
  • Contact us
  • PT
    • EN
    • FR
    • IT
    • ES
    • DE
  • 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
    • pglogical
    • Barman
    • repmgr
    • OmniDB
    • SQL Firewall
    • Postgres-XL
  • Downloads
    • Installers
      • Postgres Installer
      • 2UDA
    • Whitepapers
      • Business Case for PostgreSQL Support
      • Security Best Practices
    • 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
      • Security Best Practices
    • Blog
    • Training
      • Course Catalog
    • 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 Wegner 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
    • What does “2ndQuadrant” mean?
    • 2ndQuadrant’s Passion for PostgreSQL
    • News
    • Careers
    • Team Profile
  • Blog
  • Menu Menu
Você está aqui: 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.

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.

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.

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

Nothing Found

Sorry, no posts matched your criteria

View All Blogs

Get in touch with us!

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

Popular Articles from EDB

  • Connecting PostgreSQL using psql and pgAdmin
  • How to use PostgreSQL with Django | EDB
  • How to use PostgreSQL with Laravel | EDB
  • 10 Examples of PostgreSQL Stored Procedures
  • How to import and export data using CSV files in PostgreSQL

Featured Articles from EDB

  • PostgreSQL Replication and Automatic Failover Tutorial
  • PostgreSQL vs. SQL Server (MSSQL) - Extremely Detailed ...
  • The Complete Oracle to PostgreSQL Migration Guide ...
  • PostgreSQL vs. MySQL: A 360-degree Comparison ...
  • How to use pg_dump and pg_restore in multi-host ...

Useful Links from EDB

  • EDB Postgres Advanced Server: The Oracle Alternative
  • Backup and Recovery Tool: Disaster Recovery for PostgreSQL
  • Migration Portal: Convert Oracle database schemas to ...
  • Migration Toolkit: Command-line data migration tool
  • Managing Postgres Replication Made Easy
© 2ndQuadrant Ltd. All rights reserved. | Privacy Policy
  • Twitter
  • LinkedIn
  • Facebook
  • Youtube
  • Mail
Scroll to top
×