pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Antti Linno <alligator@all.ee>
To: pgsql-sql@postgresql.org
Subject: Re: RE:Table corrupted and data lost (second time in one month!!)
Date: Wed, 25 Apr 2001 09:05:24 +0200 (EET)
Message-ID: <Pine.LNX.4.04.10104250856290.2341-100000@all.ee> (raw)
In-Reply-To: <01042517014400.00613@spikey.slithery.org>

Hm, about memory exhausting I don't know, but the other day I tested the
limits of the text field in Postgres 6.5.(2 or 3). When ppl inserted text
in windows environment through html forms, then they got no more than
5000+a bit more symbols. Ok, I decided to test and inserted 8000+bit more
from linux and html form. What I got was corrupted table and no way to restore
data. And I am interested in parser or something too so I can see table
fields etc. to restore data if something so shitty happens. And yes I
didn't have backup, and yes it was important data :P Oh, about upgrading,
I don't maintain that machine, and half of its software should be upgraded
:P At least some little proggie to convert binary data to text would be of
some help in the future. 

Just my idle thoughts though.

Greetings,
	Antti


On Wed, 25 Apr 2001, Mark Kirkwood wrote:

> 
> 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 ;-(
> >




view thread (5+ messages)  latest in thread

Message-ID: <Pine.LNX.4.04.10104250856290.2341-100000@all.ee>
Permalink:  ../Pine.LNX.4.04.10104250856290.2341-100000@all.ee/
Also on:    postgresql.org/message-id/Pine.LNX.4.04.10104250856290.2341-100000@all.ee

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: alligator@all.ee
  Subject: Re: Table corrupted and data lost (second time in one month!!)
  In-Reply-To: <Pine.LNX.4.04.10104250856290.2341-100000@all.ee>
  References: <01042517014400.00613@spikey.slithery.org> <Pine.LNX.4.04.10104250856290.2341-100000@all.ee>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox