Re: get user info on log

[Ganesh Korde <ganeshakorde@xxxxxxxxx>]

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@xxxxxxxxxx> wrote:

Em qui., 15 de set. de 2022 às 12:59, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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