Suggestions appear as you type. Use the up and down arrows to choose one and Enter to open it.

This page's audience our own tag's counts — open to see them
–Visits
–Page views
–Clicks to vendors
–Time on page
–Reading now
Clicks to vendors, by tool
  • –
Top countries
  • –
Devices
  • –

– · visits, page views and clicks counted by our own tag, which counts more than our checked analytics; every figure rounded down · how we count

pglogical

Free#21 of 30 in Database Replication SoftwareData Replication Software

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.

7.0/10Editor score
pglogical7.0 Visit pglogical

At a glance

  • Editor score
    7.0 / 10
  • Pricing
    Open source
  • Best for
    Selective logical replication for PostgreSQL
  • Paid from
    Free
  • Change data capture
    Yes
  • Facts checked
    20 Sep 2026
pglogical screenshot
  • 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

Plans Open sourceFree Free to use — no paid tier required for the core job.
See plans on enterprisedb.com

pglogical fact sheet

Free planNot verified
Paid fromFree
Change data captureYes
Replication directionTwo-way
Deployment optionsSelf-hosted
Supported databasesPostgreSQL; Postgres-XL (subscriber only)
Cross-region replicationNot verified
Data transformationsNot verified
DeploymentSelf-hosted
PlatformsLinux
SupportDocs
Built forMid-market, Enterprise (editorial estimate)
PricingOpen source
Websiteenterprisedb.com
Facts checked20 Sep 2026

Alternatives to pglogical

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

Reviews come only from verified accounts. Sign in or create an account first — your e-mail is never shown.

Your rating

0 characters · at least 80, up to 3,000

Posted from your verified account. Reviews appear after an editor reads them, usually within two working days.

Featured on iTechGuides

Featured on iTechGuides — pglogical 7.0/10

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