Before image of selective columns.

From: Gambhir Singh <gambhir(dot)singh05(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Before image of selective columns.
Date: 2025-01-10 09:50:57
Message-ID: CAHOGQfV_CHuMJ+yo3YoYCMsajedejRa1=X84shGMSi8CKhCo5Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2025-01-10 09:55:00 Re: Before image of selective columns.
Previous Message Scott Ribe 2025-01-09 13:44:28 Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster