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
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 |