Re: how do I get a log of SQL executed by server?
От | Bruce Momjian |
---|---|
Тема | Re: how do I get a log of SQL executed by server? |
Дата | |
Msg-id | 200302121450.h1CEoRr01560@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: how do I get a log of SQL executed by server? (Robert Treat <xzilla@users.sourceforge.net>) |
Список | pgsql-general |
In 7.3, it is log_statement. --------------------------------------------------------------------------- Robert Treat wrote: > On Thu, 2003-02-06 at 12:18, Ken Guest wrote: > > with mysql it's possible to get a log of all sql that the server executes. > > Is this possible with postgres and how do I turn this on? > > > > thanks ever so much > > > > Ken > > > > > > You'll want to check out the DEBUG_PRINT_* settings in the > postgresql.conf file. See section 3.4 in the administrator's guide > -- http://www.gtsm.com/cgi/psearch?page=runtime-config.html > > Robert Treat > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
В списке pgsql-general по дате отправления: