Re: log sql?
От | Bruce Momjian |
---|---|
Тема | Re: log sql? |
Дата | |
Msg-id | 200207300414.g6U4EGI29236@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: log sql? (Andrew Sullivan <andrew@libertyrms.info>) |
Ответы |
Re: log sql?
Re: log sql? Re: log sql? |
Список | pgsql-general |
Andrew Sullivan wrote: > On Fri, Jul 26, 2002 at 03:27:45PM -0700, Laurette Cisneros wrote: > > > > Is there way to track each sql statement and the user for the server? > > Sort of. Turn on query logging in the postgresql.conf file, and also > log connections and PID. Then, you can track back by using the PID, > to discovere who logged in (and therefore, who issued that query). Andrew, what postgresql.conf parameter is query logging. I don't see it. I see: #log_connections = false #log_timestamp = false #log_pid = false -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
В списке pgsql-general по дате отправления: