Thread: 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.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