# 2ndQuadrant/pglogical

Logical Replication extension for PostgreSQL 17, 16, 15, 14, 13, 12, 11, 10, 9.6, 9.5, 9.4 (Postgres), providing much faster replication than Slony, Bucardo or Londiste, as well as cross-version upgrades.

Repository: https://github.com/2ndQuadrant/pglogical
Canonical: https://ross.abutalabs.com/products/pglogical
Homepage: https://www.enterprisedb.com/docs/supported-open-source/pglogical2/
Language: C
License: NOASSERTION
License Family: other
Topics: postgresql, replication, logical-decoding, database-replication, subscription, publish-subscribe, data-transformation, data-transport, etl, cdc, zero-downtime
Last push: 2026-07-28T18:10:14+00:00

## Health v2 (maintenance only)
Score: 84/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 94, release rhythm 63, longevity 100
- inputs: {"age_days": 3767, "days_push": 36, "days_rel": 36, "gap_med": 281, "n_releases_24m": 4}
- flags: no_license
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 1238, forks 177 (observed 2026-08-28T04:04:05.502306+00:00)

## What it is
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
- artifact type: library
- maturity: maintenance
- function: database, etl, streaming
- domain: databases
- platform: cross-platform
- tags: postgresql-extension, logical-replication, cdc, publish-subscribe, zero-downtime-upgrade, replication-sets, data-engineering, devops, linux, postgresql

## Member repositories
- 2ndQuadrant/pglogical (main) score 84

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:04:05.502306+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-30T05:10:00.486797+00:00, confidence not recorded.
  - readme: https://github.com/2ndQuadrant/pglogical (fetched 2026-08-28T04:04:05.502306+00:00, sha 0b5ca119d2be)
  - homepage: https://www.enterprisedb.com/docs/supported-open-source/pglogical2/ (fetched 2026-08-29T12:20:57.504494+00:00, sha eabd05da56f6)
  - site_page: https://www.enterprisedb.com/docs (fetched 2026-08-29T12:20:57.507897+00:00, sha 54cea3049dfa)
  - site_page: https://www.enterprisedb.com/docs/edb-postgres-ai (fetched 2026-08-29T12:20:57.510750+00:00, sha 7c18c39cc8bc)
  - site_page: https://www.enterprisedb.com/docs/edb-postgres-ai/platforms-and-tools (fetched 2026-08-29T12:20:57.513374+00:00, sha 32229978ffc5)
  - site_page: https://www.enterprisedb.com/docs/edb-postgres-ai/platforms-and-tools/high-availability (fetched 2026-08-29T12:20:57.515953+00:00, sha 8ec6514d9abe)
  - site_page: https://www.enterprisedb.com/docs/supported-open-source/pglogical2/release-notes (fetched 2026-08-29T12:20:57.518380+00:00, sha 572b1d991ed5)
  - site_page: https://www.enterprisedb.com/docs/supported-open-source/pglogical2/requirements (fetched 2026-08-29T12:20:57.520933+00:00, sha 59c9184812cb)
  - site_page: https://www.enterprisedb.com/docs/supported-open-source/pglogical2/installation (fetched 2026-08-29T12:20:57.523246+00:00, sha 9f377c12981a)
  - site_page: https://www.enterprisedb.com/docs/supported-open-source/pglogical2/usage (fetched 2026-08-29T12:20:57.529714+00:00, sha 6d06fb5a1a7c)
- Data as of 2026-08-30T08:39:29.467469+00:00.