MIME-Version: 1.0
From: Gambhir Singh <gambhir.singh05@gmail.com>
Date: Fri, 10 Jan 2025 15:20:57 +0530
Message-ID: 
 <CAHOGQfV_CHuMJ+yo3YoYCMsajedejRa1=X84shGMSi8CKhCo5Q@mail.gmail.com>
Subject: Before image of selective columns.
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c01303062b570ad3"
Archived-At: 
 <https://www.postgresql.org/message-id/CAHOGQfV_CHuMJ%2Byo3YoYCMsajedejRa1%3DX84shGMSi8CKhCo5Q%40mail.gmail.com>
Precedence: bulk

--000000000000c01303062b570ad3
Content-Type: text/plain; charset="UTF-8"

Hi,

I got a request from my application team that they want the before image of
selective columns when any delete occurs in DB. They will use this
information for some audit purposes. Also we have CDC configured between
on-prem PostgreSQL and Aurora PostgreSQL and certain tables are very large
in size and have heavy delete operations on them.

Please help me find a way to meet the app team's requirements without
impacting CDC.

Thanks & Regards
Gambhir Singh

--000000000000c01303062b570ad3
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div class=3D"gmail_default" style=3D"font-family:tah=
oma,sans-serif;font-size:small;color:rgb(0,0,0)"><span style=3D"font-family=
:Arial,Helvetica,sans-serif;color:rgb(34,34,34)">Hi,</span></div><br>I got =
a request from my application team that they want the before image of selec=
tive columns when any delete occurs in DB. They will use this information f=
or some audit purposes. Also we have CDC configured between on-prem Postgre=
SQL and Aurora PostgreSQL and certain tables are very large in size and hav=
e heavy delete operations on them.<br><br>Please help me find a way to meet=
 the app team&#39;s requirements without impacting CDC.<br></div><br><div d=
ir=3D"ltr" class=3D"gmail_signature" data-smartmail=3D"gmail_signature"><di=
v dir=3D"ltr">Thanks &amp; Regards<br>Gambhir Singh<br><br></div></div></di=
v>

--000000000000c01303062b570ad3--