Postgres Pro
Downloads
Home   >   mailing lists

Re: How to Log DBA actions - Mailing list pgsql-admin

From Daulat
Subject Re: How to Log DBA actions
Date
Msg-id CALfOM6KYD+Jc9eRdi18MU0yUpBBS5CgBvYjNJayz07+MBN0fcw@mail.gmail.com
Whole thread Raw
In response to Re: How to Log DBA actions  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Tree view
Thanks Holger ! 
It means, there is no use of pgaudit if we already have log_statements enabled?

On Mon, Dec 20, 2021 at 12:13 PM Holger Jakobs <holger@jakobs.com> wrote:
There is a setting log_statements which can be set to none (the default), ddl, mod or all

This might help.

Am 20. Dezember 2021 07:34:13 MEZ schrieb Daulat <daulat.dba@gmail.com>:
Hi Team,

I want to log DBA actions in Postgres. Can you please suggest how I can achieve it.
Will pg_audit and log_min_duration_statements help on it?

Thanks,


--
Holger Jakobs, Bergisch Gladbach
+49 178 9759012
- sent from mobile, therefore short -

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: How to Log DBA actions
Next
From: "Reno, Natalie"
Date:
Subject: RE: Reconfiguring active PostgreSQL instance