Re: Loggin SQL Statements from JBOSS/JDBC

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Thomas LeBlanc" <thomasatiem(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Loggin SQL Statements from JBOSS/JDBC
Date: 2003-11-14 17:07:37
Message-ID: 200311141707.37699.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 14 November 2003 16:15, Thomas LeBlanc wrote:
> Are there settings in PostgreSQL to log SQL Statements from client apps?
>
> Is yes, where are they logged to?
>
> We set log_statement=On, but where does the log get sritten to?

Depends on how you start PG - you'll need to check your startup scripts.

If you want to, you can set it up to use syslog (set syslog=2, see the
relevant section of the manuals)

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas LeBlanc 2003-11-14 17:08:49 Re: Loggin SQL Statements from JBOSS/JDBC
Previous Message Manfred Koizar 2003-11-14 16:51:25 Re: Conservation of OIDs