Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to Log DBA actions

How to Log DBA actions

From
Daulat
Date:
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,


Re: How to Log DBA actions

From
Holger Jakobs
Date:
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 -

Re: How to Log DBA actions

From
Daulat
Date:
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 -