| From: | Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> |
|---|---|
| To: | cgg007(at)yahoo(dot)com |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: "ERROR:" Messages |
| Date: | 2002-06-11 15:01:10 |
| Message-ID: | 20020611110110.76c829ef.nconway@klamath.dyndns.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On Tue, 11 Jun 2002 07:53:19 -0700 (PDT)
"Chris Gamache" <cgg007(at)yahoo(dot)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(at)rogers(dot)com>
PGP Key ID: DB3C29FC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Ferguson | 2002-06-11 15:03:17 | Re: "ERROR:" Messages |
| Previous Message | Chris Gamache | 2002-06-11 14:53:19 | "ERROR:" Messages |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Darren Ferguson | 2002-06-11 15:03:17 | Re: "ERROR:" Messages |
| Previous Message | Chris Gamache | 2002-06-11 14:53:19 | "ERROR:" Messages |