Re: Logging: statements and users

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Logging: statements and users
Дата
Msg-id 20031114143436.GA27483@libertyrms.info
обсуждение исходный текст
Ответ на Logging: statements and users  (ow <oneway_111@yahoo.com>)
Список pgsql-admin
On Wed, Nov 12, 2003 at 11:10:09PM -0800, ow wrote:
> Hi,
>
> It appears that pgSql can be configured to log the executed statements.
> However, the log does not appear to contain any info about who's running the
> statement. Any way to change this?

You can log the pid and log connections, and then trace back to see
who connected with that pid.  There was some discussion about
improving this for 7.4, but I don't know if any of that was done.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


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

Предыдущее
От: Dani Oderbolz
Дата:
Сообщение: Re: pg_atoi: zero-length string
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Problem with compilation 7.3.4