Re: Toasted column values during replication

From: Chandy G <vgchandru(at)yahoo(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Subject: Re: Toasted column values during replication
Date: 2023-07-15 20:42:56
Message-ID: 1225296747.546374.1689453776431@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Using pgoutput - aws rds 13* version and seeing this behavior when using it with debezium 2.0.0 version.
Best.

On Friday, 30 June, 2023 at 12:53:20 pm GMT-7, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:

On Fri, 2023-06-30 at 17:06 +0000, Chandy G wrote:
> For instance :  Can the postgres internal component (wal-sender / *) interpret this special
> toasted-col-value sitting in the wal-file -> replace it with the actual value and send it to
> the replication slot.

Which logical decoding plugin are you using?

"pgoutput", which is provided by PostgreSQL, will surely emit properly detoasted values.

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Gallo 2023-07-15 21:11:22 Re: Rocky Linux 9 and postgres10
Previous Message David G. Johnston 2023-07-15 18:09:23 Re: error in the example given for numeric data types