Re: Toasted column values during replication

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Chandy G <vgchandru(at)yahoo(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Toasted column values during replication
Date: 2023-06-30 19:52:51
Message-ID: 4cb165af29d495718a995875ad9e2af5708733bd.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nathan Bossart 2023-06-30 21:56:08 Is anyone using db_user_namespace?
Previous Message Kirk Wolak 2023-06-30 17:56:53 Re: Adding SHOW CREATE TABLE