Re: error codes in log file?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: David Parker <dparker(at)tazznetworks(dot)com>
Cc: postgres general <pgsql-general(at)postgresql(dot)org>
Subject: Re: error codes in log file?
Date: 2005-03-10 19:34:36
Message-ID: 20050310193436.GA87053@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 10, 2005 at 01:58:52PM -0500, David Parker wrote:

> Is there a postgresql.conf directive (7.4.5) which will result in error
> codes being emitted in the log file? I am thinking of the error codes
> in:
> http://www.postgresql.org/docs/7.4/interactive/errcodes-appendix.html.

You could set log_error_verbosity to 'verbose', either cluster-wide in
postgresql.conf, for a particular database with ALTER DATABASE, for a
particular user with ALTER USER, or just for a particular session with
SET. Verbose logging might show more than you want, but it'll show the
error codes.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard_D_Levine 2005-03-10 19:57:05 Re: PostgreSQL still for Linux only?
Previous Message Alex Turner 2005-03-10 19:18:35 IO Timeout