Postgres Pro
Downloads
Home   >   mailing lists

Re: More detailed error logging? - Mailing list pgsql-general

From Richard Huxton
Subject Re: More detailed error logging?
Date
Msg-id 42944085.7070106@archonet.com
Whole thread Raw
In response to More detailed error logging?  (CSN <cool_screen_name90001@yahoo.com>)
List pgsql-general
Tree view 
CSN wrote:
> Is it possible to have the database name, datetime,
> and maybe even the query itself show up in pgsql's
> error log?

Plenty of options to log all sorts of info. See the manuals chapter
"16.4.6. Error Reporting and Logging" for details.

You can even increase detail settings in one particular connection using
SET ...

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: CSN
Date:
Subject: plpython error since upgrading from 7.x to 8.x
Next
From: Richard Huxton
Date:
Subject: Re: postmaster fails to start