DB crashed

post some more informations, i.e. version, latest entries in logfile before crash, etc.

- thomas
----- Original Message -----
From: rbaisak
To: pgsql-general@postgresql.org
Sent: Monday, November 27, 2006 8:26 PM
Subject: [GENERAL] DB crashed

I have been using postgres since a long time. Recently number of users in my portal has been increased drastically and because of that load on Database server has been increased. Suddenly postgres Database crashed and I need to restart the DB. I am not able to find out root cause of this problem. I need help to get any clue regarding what query caused DB to crash. Any utility/program that can help me to debug the DB will be well appreciated.

- R

Thomas H. wrote:

post some more informations, i.e. version, latest entries in logfile
before crash, etc.

- thomas

----- Original Message -----
*From:* rbaisak <mailto:rbaisak@nyc.yamaha.com>
*To:* pgsql-general@postgresql.org
<mailto:pgsql-general@postgresql.org>
*Sent:* Monday, November 27, 2006 8:26 PM
*Subject:* [GENERAL] DB crashed

I have been using postgres since a long time. Recently number of
users in my portal has been increased drastically and because of
that load on Database server has been increased. Suddenly postgres
Database crashed and I need to restart the DB. I am not able to
find out root cause of this problem. I need help to get any clue
regarding what query caused DB to crash. Any utility/program that
can help me to debug the DB will be well appreciated.

- R

I am using Postgres 7.4.3. Unfortunately I could not able to track log
file as this was happened with live system.