log_statement setting

From: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: log_statement setting
Date: 2021-08-18 16:04:08
Message-ID: CAFS1N4jqdaGHcckabvH38i1_jmDKjB3Q-hR9VxJDZSWioQvaHQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

A doubt on the setting 'log_statement'. Is it possible to set this at
database/user level?
I get 'all' when I try
select * from pg_settings where name = 'log_statement'
Does this mean all statements by any user on any database in that server
are getting logged? This is for auditing purposes.

Regards,
Jayadevan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2021-08-18 16:06:27 Re: log_statement setting
Previous Message Heljeeve C Unni 2021-08-18 15:48:51 PostgreSQL Automatic Failover Windows Server