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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
