Re: get user info on log

Поиск
Список
Период
Сортировка
От Ganesh Korde
Тема Re: get user info on log
Дата
Msg-id CAPNyb0VH0qf8nrHEnrHPDfMGWwyKQzHSwmoMtYwoC9KVVx8SbA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: get user info on log  (Marcos Pegoraro <marcos@f10.com.br>)
Ответы Re: get user info on log  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: Extension rpath issues on MacOS
Следующее
От: "sivapostgres@yahoo.com"
Дата:
Сообщение: Re: Query Performance