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
|
| Список | 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 existNo, 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 Mauraselect 1/0; -- I would like to see this exception on log being logged as maurathanksMarcos
В списке pgsql-general по дате отправления: