| 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: | Whole Thread | Raw Message | 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 |