how do I get a log of SQL executed by server?
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
________________________________________________________________________
This email has been scanned for all viruses by the MessageLabs SkyScan
service. For more information on a proactive anti-virus service working
around the clock, around the globe, visit http://www.messagelabs.com
________________________________________________________________________
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
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.htmlRobert 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