From: Holger Jakobs <holger@jakobs.com>
To: pgsql-admin@lists.postgresql.org, Daulat <daulat.dba@gmail.com>
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: How to Log DBA actions
Date: Mon, 20 Dec 2021 07:43:45 +0100
Message-ID: <BF9C0B0F-44FD-4377-BF63-D7ABC6B0FDB3@jakobs.com> (raw)
In-Reply-To: <CALfOM6LVK2cPspzoihzp7mdr4-SaKJadvD6v+eJWbzkQth2-Rg@mail.gmail.com>
References: <CALfOM6LVK2cPspzoihzp7mdr4-SaKJadvD6v+eJWbzkQth2-Rg@mail.gmail.com>
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 -
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-admin@postgresql.org
Cc: holger@jakobs.com, daulat.dba@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: How to Log DBA actions
In-Reply-To: <BF9C0B0F-44FD-4377-BF63-D7ABC6B0FDB3@jakobs.com>
* 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