Error Logging with clusters

From: Shankar K <shan0075(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Error Logging with clusters
Date: 2003-07-29 20:13:16
Message-ID: 20030729201316.13238.qmail@web21110.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-07-29 20:25:00 Re: Replication/Failover/HA solution
Previous Message Robert Treat 2003-07-29 19:21:17 Re: translate referential integrity violation