Error Logging with clusters - Mailing list pgsql-admin

From Shankar K
Subject Error Logging with clusters
Date
Msg-id 20030729201316.13238.qmail@web21110.mail.yahoo.com
Whole thread Raw
List pgsql-admin
Hi,

I got a database cluster with multiple databases on
it. all with similar tables/indexes etc.

Now the question is, how to identify database x raised
error y (which gets logged in server logfile).

for e.g. below snip gets logged in server logfile,
which clearly tells dummy_id is not a column of
temp_table. however it doesn't say what database or
schema.

2003-07-29 12:13:14 ERROR:  No such attribute
temp_table.dummy_id

i have log_min_error_statement, server_min_messages to
its defaults which is error and notice respectively. I
tried log_statement=true, but that didn't help either.


Is there any way i could get that info.

thanks
Shankar

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com

pgsql-admin by date:

Previous
From: Robert Treat
Date:
Subject: Re: translate referential integrity violation
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: Replication/Failover/HA solution