Postgres Pro
Downloads
Home   >   mailing lists

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

From Holger Jakobs
Subject Re: How to Log DBA actions
Date
Msg-id BF9C0B0F-44FD-4377-BF63-D7ABC6B0FDB3@jakobs.com
Whole thread Raw
In response to How to Log DBA actions  (Daulat <daulat.dba@gmail.com>)
Responses Re: How to Log DBA actions  (Daulat <daulat.dba@gmail.com>)
List pgsql-admin
Tree view
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: Daulat
Date:
Subject: How to Log DBA actions
Next
From: Daulat
Date:
Subject: Re: How to Log DBA actions