Re: "ERROR:" Messages - Mailing list pgsql-general

From Neil Conway
Subject Re: "ERROR:" Messages
Date
Msg-id 20020611110110.76c829ef.nconway@klamath.dyndns.org
Whole thread Raw
In response to "ERROR:" Messages  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-general
On Tue, 11 Jun 2002 07:53:19 -0700 (PDT)
"Chris Gamache" <cgg007@yahoo.com> wrote:
> I'm getting ERROR: messages on the console (and rightly so!) ... My question
> is, how can I find out what the text of the failed query would be.

Set "debug_print_query = true" in postgresql.conf and send the postmaster a
SIGHUP.

> I compiled --without-syslog to eek the last bit of performance out of
> PostgreSQL.

I'd be surprised if that had any performance impact, particularly since
logging through syslog is disabled by default.

Cheers,

Neil

--
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC

pgsql-general by date:

Previous
From: Chris Gamache
Date:
Subject: "ERROR:" Messages
Next
From: Darren Ferguson
Date:
Subject: Re: "ERROR:" Messages