search

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.
http://2ndquadrant.com/en/resources/pglogical/
Other
1.01k stars 154 forks source link

What is the difference between using this extension and inbuilt logical replication? #449

Closed drticcz closed 9 months ago

drticcz commented 11 months ago

I cannot find out what is the difference. The documentation here involves installing and loading an extension, while the official Postgres guide describes a slightly different approach to running the logical replication which works without installing and loading any extension.

Is the documentation here just outdated or the extension codebase is different than the "inbuilt Postgres logical" ?

dubek commented 10 months ago

Here's a post for 2017 explaining this: https://www.2ndquadrant.com/en/blog/pglogical-logical-replication-postgresql-10/

Besides the different syntax, pglogical has some features not available in current Postgres (16), such as conflict resolution.

drticcz commented 9 months ago

Thanks, this explains a lot!