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

Large objects documentation wrong? #467

Closed jcoleman closed 6 months ago

jcoleman commented 6 months ago

The README says:

Large objects

PostgreSQL's logical decoding facility does not support decoding changes to large objects, so pglogical cannot replicate large objects.

I can only imagine this refers to TOAST since I'm not sure what other Postgres feature "large objects" would refer to, but there are in-project tests for replication of TOASTed values, and our own testing confirms the same.

Is this outdated documentation (maybe it was true in a very old version of Postgres)? Or is there something else this refers to?

nmisch commented 6 months ago

This refers to https://www.postgresql.org/docs/current/largeobjects.html, stored in pg_largeobject.

jcoleman commented 6 months ago

Ah, I wasn't aware of that facility.

Thanks for clarifying.