On Fri, 2006-08-25 at 15:42 -0400, Alvaro Herrera wrote:
> SHOW lc_messages, I think. Is it something else than C? If so, it will
> probably try to read the corresponding postgres.mo file. Do the hung
> processes have that file open? (I'm not sure if you can find that out
> from only the core file.)
>
Database=# SHOW lc_messages;
lc_messages
-------------
en_US.UTF-8
(1 row)
Database=#
We don't think we can find this from the core file either. Next time it
happens we will check whether postgres.mo is in use. Unfortunately we
are no longer seeing the problem. We'll let you know when we have more.
Thanks for the quick response.
__
Marc