Re: How To Log User Name + Database?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How To Log User Name + Database?
Дата
Msg-id 9838.976123476@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How To Log User Name + Database?  (Ed Loehr <eloehr@austin.rr.com>)
Ответы Re: How To Log User Name + Database?  (Larry Rosenman <ler@lerctr.org>)
RE: How To Log User Name + Database?  ("Edmar Wiggers" <edmar@brasmap.com>)
Список pgsql-general
Ed Loehr <eloehr@austin.rr.com> writes:
> Can anyone tell me how to log the db user name and db name to the server
> log?  Is this possible at present?

Offhand I don't think that happens at the moment, but it does seem like
it'd be a good idea to have a backend do an elog(DEBUG) at startup that
mentions its database name and user name.  Assuming you have logging of
timestamps/PIDs turned on, that would be enough to correlate later log
messages with a user name.

Comments anyone?

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Ed Loehr
Дата:
Сообщение: How To Log User Name + Database?
Следующее
От: Larry Rosenman
Дата:
Сообщение: Re: How To Log User Name + Database?