2ndQuadrant/pglogical

Health v2 · maintenance only

Flags: no_license

Adoption not part of the score

1238 stars · 177 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

pglogical is a PostgreSQL extension providing logical streaming replication using a publish/subscribe model, written in C. It supports selective table/row/column replication, multi-origin merging with conflict resolution, cascading replication, and cross-major-version upgrades, and is maintained by EDB (with deprecation planned after v18).

Use cases

• replicate a postgres database to another server with low lag
• upgrade postgres across major versions with zero downtime
• replicate only selected tables or rows to a subscriber
• merge data from multiple upstream postgres servers into one
• set up change data capture from postgres for ETL pipelines
• fan out one provider database to many subscribers

When to choose

• you need faster, more flexible replication than Slony, Bucardo, or Londiste
• you want selective replication of tables, rows, or columns via replication sets
• you need cross-version PostgreSQL upgrades with minimal downtime
• you must merge changes from several origins with conflict resolution

When to avoid

• you need full multi-master clustering - use EDB Postgres Distributed (PGD) instead
• you are on PostgreSQL 10+ and only need basic replication - built-in logical replication may suffice
• you require long-term support - pglogical 2 is deprecated after v18
• provider and subscriber schemas, columns, or primary keys cannot be kept identical

Facets

library · maturity maintenance

database etl streaming databases cross-platform postgresql-extension logical-replication cdc publish-subscribe zero-downtime-upgrade replication-sets data-engineering devops linux postgresql

Member repositories

For agents

markdown · JSON · MCP: product_card(name="2ndQuadrant/pglogical")