pglogical
pglogical: A focused PostgreSQL replication extension for selective, multi-node data movement. Ranked #21 of 30 in Database Replication Software by our editors (7.0/10); pricing: Open source; best for selective logical replication for PostgreSQL.
At a glance
- Editor score7.0 / 10
- PricingOpen source
- Best forSelective logical replication for PostgreSQL
- Paid fromFree
- Change data captureYes
- Facts checked20 Sep 2026

Where it wins
- Selective replication with row, column, and replication-set filters
- Supports multi-subscriber, multi-upstream, and cascading designs
- Conflict detection with configurable conflict resolution
Where it doesn't
- Self-hosted Linux deployment requires PostgreSQL administration
- Database coverage centers on PostgreSQL; Postgres-XL is subscriber-only
- EDB support for pglogical 2 ends after PostgreSQL version 18
Our verdict on pglogical
pglogical is an open-source PostgreSQL extension for logical streaming replication through a publish/subscribe model. It is designed for teams that need to move selected database objects or entire databases between PostgreSQL provider and subscriber nodes. The extension supports replication across supported PostgreSQL major versions, making it relevant for PostgreSQL migrations, distributed deployments, and architectures that need more control than full-database copying alone. It runs in a self-hosted environment on Linux and supports PostgreSQL as its primary database platform, with Postgres-XL supported as a subscriber.
Selective replication is the product’s defining strength. Replication sets can target specific data, while row and column filtering provide additional control over what moves between nodes. pglogical also supports one provider replicating to multiple subscribers, merging changes from multiple upstream servers, and cascading replication through changeset forwarding. Conflict detection and configurable conflict resolution add support for designs where changes can travel in more than one direction. Together, these features make pglogical a suitable choice for PostgreSQL environments with selective distribution, multi-upstream requirements, or staged replication paths.
The main trade-off is focus. pglogical is built around PostgreSQL rather than a broad database ecosystem, and its self-hosted deployment places installation and operation within the team’s environment. Its lifecycle also matters: EDB states that pglogical 2 support ends after version 18 and recommends native PostgreSQL logical replication for version 19 onward. Choose pglogical when its filtering, multi-subscriber, multi-upstream, conflict-handling, or cascading capabilities match a PostgreSQL architecture. Choose another option when you need broader database coverage or a longer-term path centered on native PostgreSQL logical replication.
Your product? Our editors can test pglogical in depth and publish a review, labelled as paid · from $149/mo →
pglogical pricing
pglogical fact sheet
| Free plan | Not verified |
|---|---|
| Paid from | Free |
| Change data capture | Yes |
| Replication direction | Two-way |
| Deployment options | Self-hosted |
| Supported databases | PostgreSQL; Postgres-XL (subscriber only) |
| Cross-region replication | Not verified |
| Data transformations | Not verified |
| Deployment | Self-hosted |
| Platforms | Linux |
| Support | Docs |
| Built for | Mid-market, Enterprise (editorial estimate) |
| Pricing | Open source |
| Website | enterprisedb.com |
| Facts checked | 20 Sep 2026 |
Alternatives to pglogical
- Oracle GoldenGateA broad enterprise replication platform with free, managed OCI, and BYOL options.9.4
- SymmetricDSA flexible replication platform for multi-primary synchronization across many database environments.9.2
- StriimA broad replication platform with visual pipelines, continuous CDC, and a free developer tier.9.0
See all pglogical alternatives →
Also Ranked In
pglogical is ranked in 2 of our directories.
Used pglogical? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used pglogical for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
pglogical is listed in our Database Replication Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/pglogical/"><img src="https://www.itechguides.com/best/badge/pglogical.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Oct 2026
Advertiser disclosure: iTechGuides is reader-supported. Vendors can pay for top positions in our rankings and for a place on other products' pages, and we may earn a commission when you click some links. Bought places stand at the number bought; this page and our disclosure say so. Paying vendors may get a fuller, more detailed review from our editors, and that review can change their score. How we rank.
Last updated · How we research and update



