Re: Binary support for pgoutput plugin

Dave Cramer <davecramer@gmail.com>

From: Dave Cramer <davecramer@gmail.com>
To: Andres Freund <andres@anarazel.de>
Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2019-06-09T00:40:43Z
Lists: pgsql-hackers
On Sat, 8 Jun 2019 at 20:09, Andres Freund <andres@anarazel.de> wrote:

> Hi,
>
> On 2019-06-08 19:41:34 -0400, Dave Cramer wrote:
> > So the reason we are discussing using pgoutput plugin is because it is
> part
> > of core and guaranteed to be in cloud providers solutions.
>
> IMO people needing this should then band together and write one that's
> suitable, rather than trying to coerce test_decoding and now pgoutput
> into something they're not made for.
>

At the moment it would look a lot like pgoutput. For now I'm fine with no
changes to pgoutput other than binary
Once we have some real use cases we can look at writing a new one. I would
imagine we would actually start with
pgoutput and just add to it.

Thanks,
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.