From: Chandy G <vgchandru@yahoo.com>
To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Subject: Re: Toasted column values during replication
Date: Sat, 15 Jul 2023 20:42:56 +0000 (UTC)
Message-ID: <1225296747.546374.1689453776431@mail.yahoo.com> (raw)
In-Reply-To: <4cb165af29d495718a995875ad9e2af5708733bd.camel@cybertec.at>
References: <676545357.616656.1688144798077.ref@mail.yahoo.com>
<676545357.616656.1688144798077@mail.yahoo.com>
<4cb165af29d495718a995875ad9e2af5708733bd.camel@cybertec.at>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: vgchandru@yahoo.com, laurenz.albe@cybertec.at
Subject: Re: Toasted column values during replication
In-Reply-To: <1225296747.546374.1689453776431@mail.yahoo.com>
References: <676545357.616656.1688144798077.ref@mail.yahoo.com> <676545357.616656.1688144798077@mail.yahoo.com> <4cb165af29d495718a995875ad9e2af5708733bd.camel@cybertec.at> <1225296747.546374.1689453776431@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox