Re: get user info on log - Mailing list pgsql-general

From Ganesh Korde
Subject Re: get user info on log
Date
Msg-id CAPNyb0VH0qf8nrHEnrHPDfMGWwyKQzHSwmoMtYwoC9KVVx8SbA@mail.gmail.com
Whole thread Raw
In response to Re: get user info on log  (Marcos Pegoraro <marcos@f10.com.br>)
Responses Re: get user info on log
List pgsql-general
Hi,

  You can use log_line_prefix in postgresql.conf to log the user name into the logs.

Regards,
Ganesh Korde.

On Fri, 16 Sep 2022, 6:31 pm Marcos Pegoraro, <marcos@f10.com.br> wrote:
Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver <adrian.klaver@aklaver.com> escreveu:
test(5432)=# set role maura;
ERROR:  role "maura" does not exist
test(5432)=# SET SESSION AUTHORIZATION 'maura';
ERROR:  role "maura" does not exist

No, I was asking about an error occurring later, not on set session authorization command.

set role maura; 
--user Maura exists and set was done correctly
--now I´m working as Maura
select 1/0; -- I would like to see this exception on log being logged as maura

thanks
Marcos

pgsql-general by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Extension rpath issues on MacOS
Next
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: Query Performance