Received: from smtp-2.attica.net.nz (pop3-2.attica.net.nz [202.180.73.237]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3P56P363998 for ; Wed, 25 Apr 2001 01:06:25 -0400 (EDT) (envelope-from markir@i4free.co.nz) Received: (qmail 35423 invoked from network); 25 Apr 2001 05:05:00 -0000 Received: from mail.attica.net.nz (HELO spikey.slithery.org) (202.180.64.33) by pop3-2.attica.net.nz with SMTP; 25 Apr 2001 05:05:00 -0000 Content-Type: text/plain; charset="iso-8859-1" From: Mark Kirkwood To: "J.Fernando Moyano" Subject: RE:Table corrupted and data lost (second time in one month!!) Date: Wed, 25 Apr 2001 17:01:44 +1200 X-Mailer: KMail [version 1.2] Cc: pgsql-sql@postgresql.org MIME-Version: 1.0 Message-Id: <01042517014400.00613@spikey.slithery.org> Content-Transfer-Encoding: 8bit X-Archive-Number: 200104/372 X-Sequence-Number: 2730 Previously... >FATAL 1: Memory exhausted in AllocSetAlloc() >pqReadData() -- backend closed the channel unexpectedly. >This probably means the backend terminated abnormally >before or while processing the request. > >A table has been corrupted and i don't know why... >It's really hard to recover the table, and last time i lost some data ;-( > I have never used 7.0.2 for any length of time....but I would recommend upgrading to 7.1 - many bugs have been fixed in this release - and hopefully not too many more introduced :) also adding more RAM would be a good idea, as 64Mb is not much these days ( I use apache 1.3.19 + mod perl 1.25 and regularly see 150Mb RSS when I run gtop ) This may be a Red Herring, but check to see you are not exhausing your swap space, as all sorts of odd errors can be encouraged by this... Cheers Mark