Re: BUG #3115: backend died abnormally HELP!!

Bryan O'Neill wrote:
> PostgreSQL version: 7.2.3

That's a very old and unsupported version. You should upgrade,
regardless of this problem.

> Operating system:   Redhat 8.0
> Description:        backend died abnormally  HELP!!
> Details:
>
> On 3/4/07, I received the following message from the subject pc:
> "NOTICE:  Message from PostgreSQL backend:
> The Postmaster has informed me that some other backend
> died abnormally and possibly corrupted shared memory.
> I have rolled back the current transaction and am
> going to terminate your database system connection and exit.  Please
> reconnect to the database system and repeat your query."  I think this
> happened on 1/27/07 also but I don't recall getting the error message
> although I could not access the database until after a cold restart.  This
> pc has run postgresql without any trouble since Nov. 2003, until the last
> few weeks.  One other thing I note was that the /var partition was 98% full!

What partition is your database in? Is there something in the logs?

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com