pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Nico Williams <nico@cryptonector.com>
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-generallists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately
Date: Wed, 16 Apr 2025 14:59:37 -0500
Message-ID: <aAAMKfepHe5lZWtC@ubby> (raw)
In-Reply-To: <CANzqJaCTCJHZtiL6Y48Bp7si+MasnrV95+y0jgGxtm4yMH83gA@mail.gmail.com>
References: <CAD5k+7zxAmkoOeVq61gqg1xWu8egSjcRtAT=rrAF=ihxUjdTMQ@mail.gmail.com>
	<CAHsK0FqMEoZ_EL6bdHL=MO6irp3uXa5iC_T9jKuCgwRcOQ=Feg@mail.gmail.com>
	<54b3d612-363e-4c05-8a08-a7563c7d52f1@cloud.gatewaynet.com>
	<CANzqJaBCYU84zhZKRzk6Ec-e1L+ZhJW=kg8P0PKNNKh8aK4ZkQ@mail.gmail.com>
	<d30c5ad3-5d31-4261-b62a-8454cf0d050e@cloud.gatewaynet.com>
	<CANzqJaAm_HSUxRVM7DvMDOVPY4Up3yKTcMa0pQ6SAJ7BFk2qGQ@mail.gmail.com>
	<aAAIPiQ7kwW3sU1M@ubby>
	<CANzqJaCTCJHZtiL6Y48Bp7si+MasnrV95+y0jgGxtm4yMH83gA@mail.gmail.com>

On Wed, Apr 16, 2025 at 03:53:53PM -0400, Ron Johnson wrote:
> On Wed, Apr 16, 2025 at 3:42 PM Nico Williams <nico@cryptonector.com> wrote:
> > I would care about what happened.  To know what happened I'd have to see
> > either only audit logs for committed transactions, or also see the
> > COMMIT and ROLLBACK statements.
> 
> Decode the logical replication stream?

Yes, or use Debezium or the like which... do just that.





view thread (12+ messages)

Message-ID: <aAAMKfepHe5lZWtC@ubby>
Permalink:  ../aAAMKfepHe5lZWtC@ubby/
Also on:    postgresql.org/message-id/aAAMKfepHe5lZWtC@ubby

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: nico@cryptonector.com, ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org
  Subject: Re: Best Tool for PostgreSQL Auditing and Storing Audit Logs Separately
  In-Reply-To: <aAAMKfepHe5lZWtC@ubby>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox