Error Logging with clusters

Поиск
Список
Период
Сортировка
От Shankar K
Тема Error Logging with clusters
Дата
Msg-id 20030729201316.13238.qmail@web21110.mail.yahoo.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: translate referential integrity violation
Следующее
От: Rajesh Kumar Mallah
Дата:
Сообщение: Re: Replication/Failover/HA solution