Re: Binary support for pgoutput plugin

Dave Cramer <davecramer@gmail.com>

From: Dave Cramer <davecramer@gmail.com>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Andres Freund <andres@anarazel.de>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2019-06-10T11:27:41Z
Lists: pgsql-hackers
So back to binary output.

From what I can tell the place to specify binary options would be in the
create publication and or in replication slots?

The challenge as I see it is that the subscriber would have to be able to
decode binary output.

Any thoughts on how to handle this? At the moment I'm assuming that this
would only work for subscribers that knew how to handle binary.

Regards,

Dave


>

Commits

  1. Weaken type-OID-matching checks in array_recv and record_recv.

  2. Fix construction of updated-columns bitmap in logical replication.

  3. Allow logical replication to transfer data in binary format.

  4. Phase 2 pgindent run for v12.