Re: Toasted column values during replication - Mailing list pgsql-general

From Chandy G
Subject Re: Toasted column values during replication
Date
Msg-id 1225296747.546374.1689453776431@mail.yahoo.com
Whole thread Raw
In response to Re: Toasted column values during replication  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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.albe@cybertec.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



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: error in the example given for numeric data types
Next
From: Daniel Gallo
Date:
Subject: Re: Rocky Linux 9 and postgres10