Re: How to Log DBA actions

From: Holger Jakobs <holger(at)jakobs(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org, Daulat <daulat(dot)dba(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: How to Log DBA actions
Date: 2021-12-20 06:43:45
Message-ID: BF9C0B0F-44FD-4377-BF63-D7ABC6B0FDB3@jakobs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(dot)dba(at)gmail(dot)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 -

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daulat 2021-12-20 06:54:14 Re: How to Log DBA actions
Previous Message Daulat 2021-12-20 06:34:13 How to Log DBA actions