Re: Db and schema names in logged errors - Mailing list pgsql-general

From Michael Fuhr
Subject Re: Db and schema names in logged errors
Date
Msg-id 20050712141520.GA84876@winnie.fuhr.org
Whole thread Raw
In response to Db and schema names in logged errors  ("Karl O. Pinc" <kop@meme.com>)
Responses Re: Db and schema names in logged errors
List pgsql-general
On Mon, Jul 11, 2005 at 07:43:48PM +0000, Karl O. Pinc wrote:
> Is there any way to get the DB and schema name into
> error messages, particularly when the errors
> are logged?  I'd like to be able to distinguish
> errors coming from the test databases from those
> coming from the live databases.

To see how logging can be configured, refer to "Error Reporting and
Logging" in the "Server Run-time Environment" chapter of the
documentation.  If you're using 8.0 then you might be interested
in the log_line_prefix setting.

http://www.postgresql.org/docs/8.0/static/runtime-config.html#RUNTIME-CONFIG-LOGGING

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: index bloat
Next
From: "Ets ROLLAND"
Date:
Subject: Pb with boolean between MS-Access and PostgreSQl 8.0.3