Re: Database server restarting

From: "shoaib" <shoaibm(at)vmoksha(dot)com>
To: "'Martijn van Oosterhout'" <kleptog(at)svana(dot)org>
Cc: <gearond(at)cvc(dot)net>, "'Nigel J(dot) Andrews'" <nandrews(at)investsystems(dot)co(dot)uk>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Database server restarting
Date: 2003-05-06 06:46:43
Message-ID: 004701c3139b$4212c1d0$131f020a@vmoksha
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

There are some cron jobs running at the same time...
One server does SSH into our application server and on cron job is
reading the DB and writing some data into flat files. But by the time
this problem is happening these jobs are not writing any data. Last
night when the server went down the other server wa trying to do SsH and
probably it was running some cron job and a heavy DB process was
running.I can not do a top bcoz I can not login into server even from
console.

Regards
shaoib

-----Original Message-----
From: Martijn van Oosterhout [mailto:kleptog(at)svana(dot)org]
Sent: Tuesday, May 06, 2003 2:40 PM
To: shoaib
Cc: gearond(at)cvc(dot)net; 'Nigel J. Andrews'; pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Database server restarting

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(at)svana(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Shridhar Daithankar 2003-05-06 06:56:36 Re: Installin Postgres
Previous Message Nigel J. Andrews 2003-05-06 06:40:40 Re: how to restrict inner results in OUTER JOIN?