Thread: Db and schema names in logged errors
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.
Thanks.
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein
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/
On 07/12/2005 09:15:20 AM, Michael Fuhr wrote: > 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? > > 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 Thanks. Don't know how I missed that. I swear I looked. Would be nice if there was a way to put the current schema into the log prefix. Karl <kop@meme.com> Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein