Re: Another way to do audit in DML operations in PostgreSQL >= 14

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Lucio Chiessi <lucio(dot)chiessi(at)trustly(dot)com>
Cc: PGSql Admin list <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Another way to do audit in DML operations in PostgreSQL >= 14
Date: 2024-02-22 23:36:43
Message-ID: Zdfai2N1GC8P8JXH@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Feb 22, 2024 at 04:14:24PM -0300, Lucio Chiessi wrote:
> As a Fintech company, we MUST audit (by force of law) all DML operations
> (select, insert, update, delete) occurring on our PostgreSQL databases.

FYI, DML is data manipulation language (DML), and SELECT is not DML. I
don't know the answer to your performance question.

--
Bruce Momjian <bruce(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

Only you can decide what is important to you.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ravindranathan Rinilnath (Ext. - UniCredit) 2024-02-23 02:04:20 Postgres Table column translation
Previous Message Ron Johnson 2024-02-22 19:49:53 Re: Would you ever recommend Shared Disk Failover for HA?