Re: How to Log DBA actions

[Nikolay Samokhvalov <samokhvalov@xxxxxxxxx>]

On Tue, Dec 21, 2021 at 1:31 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:

Nikolay Samokhvalov <samokhvalov@xxxxxxxxx> writes:
> On Sun, Dec 19, 2021 at 10:43 PM Holger Jakobs <holger@xxxxxxxxxx> wrote:
>> There is a setting log_statements which can be set to none (the default),
>> ddl, mod or all

> ..and, unfortunately, any user will be able to set it back via SET.

Really?

You're right, I was wrong.

postgres=# select context from pg_settings where name = 'log_statement';
  context
-----------
 superuser

(1 row)