Re: Database server restarting - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Database server restarting
Date
Msg-id 20030506064001.GG10957@svana.org
Whole thread Raw
In response to Re: Database server restarting  ("shoaib" <shoaibm@vmoksha.com>)
Responses Re: Database server restarting  ("shoaib" <shoaibm@vmoksha.com>)
List pgsql-general
On Tue, May 06, 2003 at 02:28:57PM +0800, shoaib wrote:
> When I say hangs it means ..I am not even able to login at the server
> console also.
> No ssh, no login form remote machines.

Well, that's not postgresql's fault. It can't hang a machine like that. You
should look elsewhere for the exact cause. I'm assuming here that consoles
that are still logged in don't respond either? Maybe leave a top running to
capture the list of processes just before it dies? Any cronjobs about the
time it dies?

What other processes run at about that time?
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Attachment

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Database server restarting
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: how to restrict inner results in OUTER JOIN?