Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qKm6j-001W4m-7P for pgsql-general@arkaria.postgresql.org; Sat, 15 Jul 2023 20:43:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qKm6f-004hPK-Qf for pgsql-general@arkaria.postgresql.org; Sat, 15 Jul 2023 20:43:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qKm6f-004hPC-9x for pgsql-general@lists.postgresql.org; Sat, 15 Jul 2023 20:43:09 +0000 Received: from sonic311-21.consmr.mail.sg3.yahoo.com ([106.10.244.38]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qKm6c-000gLb-LI for pgsql-general@lists.postgresql.org; Sat, 15 Jul 2023 20:43:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1689453781; bh=paGoGjW9RlfoANKE9w5Odh3uTwbMvBqdKMXea3ydefk=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=I8B8r4EjJTAXl6AS0ssdOgLLDKNZPE99f3ueWL5Rc4fHwJorYpW4J4hVFpyYmd6f79AiD903a9FyKJs31GeVnswzS685LhzRdDvtYoA+NlNldzdyl+mcKoY/XB4tOSgNuBa10N9I86DKdA7oORTUkbDgUab3tdTENC+8C2pSu5akFslPvlZmwNZZMOhTQ1AZQtxyEQAMn6JHxaIc8GT9HEkj1EyvZDi/1eUp5WqBv3Ee3/649k1HCb7j/ENaIsT/zN27VHBMMxMSQhjy1NVs+B9+GPMQxOeEqDR604HYe17CGz2OjIAJu/k992aSTDseuVGWd12kmN5ZTwC0Efbijw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1689453781; bh=HgV5YQVHNUrTaAKqIkWWQMvrQl+9O4sjDRCDKZ0sVCO=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=bYOXM8/7zJb0lHY+7a3V3GR6/HyeWPLXvNLopejlHryGc4HJB38AA/5Lf8IrNSvkzULIIlKxKp+N+fVeKnBkGcvTvK3tiLiq8sQGiyksk+62PW5DcIG/q2rvT2VOtLgLNxOCzaNMAJljYuFk2e2ZHS+PwzSQfdvazx2N9gVbHZ3y/921R4QzT2ie8hjSyNAHBUoT29Qi40Ektc6S8g22bI9tudPo5QqBQ4Jh6AY7T4zYQ5fe/viSM0y6+T7Fm0VMPE66CU2YFic1mX8+WiF4IyEajLx4N030hJpA26vuIlCigg9haRpTgsI2oXaCgZ1uqE0+WR2m883OWRezE3iz7g== X-YMail-OSG: zEYWKxcVM1m8RShlxU8.FWCGMpVGmy2s9jAMXW3QrRLtUa289Paq5O428e6EM6f a6Ne44XKvjNS7FH.wbAdiPHbg1nrVGU7HmwfGjBobrcHnFhFZGVf32VmAu4d.nedzPRr2NABWEa. _bazZvjEJv8wQdK3DOdSExPuK9eIBhbhwIPqHmKgyGDLUBYDgRejCARFA3Tz7Sd9KOM0gAiKZ_wL Nxwfdvrg0ODQuaWmEeP_LlHYlf7fwv08oAGlENurYAMluGyQr32Yuo5AM4j_FZJkRUBzwMdpHcqq mCdM7trd6VZpRF2rwxr3s0HXQBnClcHuCzBArU1MQdQpiCxlhPkV_aWiTYSUjJw.Twkps7bpkW.h VepDTJWtowjk7Th_56xw0Zea_fJG01jfoJu_DPpfZd6wlHFaBmw1KSdTPx69ksSX8xMa.gMe0Rn7 JHwQoG2PLCF2pwfo8b7tF5RSzNBySUCdUEijT_GpTt5kbCH.C0.NUnUrjY_uNpm16xnIkbBW2GIq rxGgC6tB25nnZ23UM2egnuuH1x_hFZiEjkpWG6WP.CL9XTVj_XOBexlYShkv_WjExF7XXP43jzil eV7cGNtztSygBYTLeB38Ve3fBiXOWFNRc8zxFB_XaWgP..0qz3sgXKFuXxSJqGBncb2.DtncNglu 8q3E526_IJHWntGHmD_x68ZBaJLwvMPhO1MA01Sh5n981W40fjiw74LTIT9pzCYdPdup6giNGnuK x06uxLOFcC_IY14v.Y9YOUP8EsklL5_4Q7HAUX83DdfHU3QG4bFkFvMgcGW1n9CIaEWLfXMuLbX5 DJ5RNNHVNhK803fFuFPgZ1HQ_hMEBgsncKhbzFqV.dBWZnRbMC.xAPqs9XEmFi8QlGVHLEwzWe7P KLubH4tuYjRxP1_LH0qflTdDFytuo705kyEokwVc.l1CAP281FNiyjUfPa3haXYwMlaBG54Fk1Gz LwsH6JX472g_iyvut13pQmsRKRqnVWTGoBi5MvIRGCqoGKipQo5hik_qpNcY5LGuh6F1RSDO7uYd ZA.zP4NP1lhjRCYPr2dyrZ9ljkKUm_HvGuHe8OhXl2j.lal_joTpZMojrE2VU3lerZOD4_8xD4Eg GaUJVjZRVcY2QE1qUq3wOSifT5BrbK03lUxqvJ8cPIotWLhxzvB14B6_E64ETQD8KU04ijtKgtZ2 KeGezcr_sseF0frNFo20jHii73xHg2rUjjCPBaI28W_xn_qykS.vCm7ZmkMaevYcZWN1MgdYSBEt bzaKhBtfPNwK7opjqBPETYyNfGQe8DQXI_dE3AUEC3kyhAEoWIRSKkeNfAhBPiAyaBx3lfE_anui RRSMys_npSlEJfIdGM.z88vT4L_NGS14EtaPcwMfnuTqq1QmiUow1Qh_sKroV8mSxu65h1sy8GhY B4FxyWY0f8VNIklI..WuZuiko2fE8GRO2QkwONKoGH5gDBAKhzzhPYGovMoRtVAcIRmaud2OvdZj pDY2zlZsWv2DuzNjfauoCUDx2Cu2sY2rzIuiPbGrNTByBcCpIDQocafvMidBhEdQhr.hgAeBdIBB yfFggCSndTvwvyICV8d7QaMrffJfhUepJCjy5Al7i.6L3L5c8.QFTO_dKo8iFZTdMKl5AzCrL4Ab 4yxiLvlTTHPrPi25CUmRe0S5VCS.X98ca1Ly3ZE2CI_nQfmK8UxDB3VlVO7J5kYYUz5tEt68qiyO hB6sNC2nvZ7OClPTvwwQlSxNp05bDalO1_6dGar_IbWFzrZ5kBeNgTwI5KZ5wOlH0.vRSkfxYDjh qhwXrv7M91rV.BsXeumpsuC1x3k6kmpBHAQwKDz1Vq1AaMHbn6EMQQGNiAgHygsEt_euAl.NaDjJ FT1.jXl8liofPhfpLGo8k1L6CmXt66SNrifuvjWgB6hJ.Ndo3bKmAg8VXHXLoGPMu6xNSfDBiAyQ IAtjXs2L6vFSO_MBxn060GUud74ooqxYApJoE5X.Y3MBW_qLfWBZWBmsMtvwQ1sKPtnRFUGYMrv4 6NhXFgLPFMKV73x.6kg1eURv3s1B64dAzVZUB.9dVNmtjVGrHlUuQiMVb2.DEyNdXlSb_pyn2EKy 0rnhyXNE9qUtBJj9f2yaPU1_F8zpY.n1cn17tXBHmPWkqZCBingLXYevurqN_kCAiOJuomqK.Z5S h0TT5B5LKY9llO6GFWbi9HoigtZ40DXp1pNTLW2IFD7JnApL9bCyz88zw1z2LAYQCY6ZBBAhNkr. LM3CuC3iQxWZnpaKZbLF1L7JfkzXzRJHV6XwLTTE1Yfn9FT._P.Xx4uU- X-Sonic-MF: X-Sonic-ID: 97c060a7-d213-4452-b227-52219b9b3293 Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.sg3.yahoo.com with HTTP; Sat, 15 Jul 2023 20:43:01 +0000 Date: Sat, 15 Jul 2023 20:42:56 +0000 (UTC) From: Chandy G To: "pgsql-general@lists.postgresql.org" , Laurenz Albe Message-ID: <1225296747.546374.1689453776431@mail.yahoo.com> 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> Subject: Re: Toasted column values during replication MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_546373_183159562.1689453776430" X-Mailer: WebService/1.1.21647 YMailNorrin Content-Length: 2742 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_546373_183159562.1689453776430 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Using pgoutput - aws rds 13* version and seeing this behavior when using i= t with debezium 2.0.0 version. Best. On Friday, 30 June, 2023 at 12:53:20 pm GMT-7, Laurenz Albe wrote: =20 =20 On Fri, 2023-06-30 at 17:06 +0000, Chandy G wrote: > For instance : =C2=A0Can the postgres internal component (wal-sender / *)= interpret this special > toasted-col-value sitting in the wal-file -> replace it with the actual v= alue and send it to > the replication slot. Which logical decoding plugin are you using? "pgoutput", which is provided by PostgreSQL, will surely emit properly deto= asted values. Yours, Laurenz Albe =20 ------=_Part_546373_183159562.1689453776430 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
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



------=_Part_546373_183159562.1689453776430--