Re: Need some urgent help. - Mailing list pgadmin-support

From Naveen Kaul
Subject Re: Need some urgent help.
Date
Msg-id 00ce01c20566$9f313340$5e8841ca@systelslaptop
Whole thread Raw
In response to Re: Need some urgent help.  (Dave Page <dpage@vale-housing.co.uk>)
List pgadmin-support
Hi Dave,
 
I have a problem with postgres. One of my table hold about 65,000 records. If I use the simple select * on this table, the pgadmin tool hangs and the postgres throws up the following exception.
 
"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.
        server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request."
 
I wonder what could be wrong. I increased the the buffer size from 256 to 512. Still the same thing.
 
Your help would be highly apperciated.
 
Thanks,
 
Naveen
 
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.351 / Virus Database: 197 - Release Date: 4/19/2002

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Cache lookup error
Next
From: "Dave Page"
Date:
Subject: Re: Need some urgent help.