X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id DFA499DCDA2
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Fri, 10 Feb 2006 10:18:13 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 86893-08-5
	for <pgsql-admin-postgresql.org@localhost.postgresql.org>;
	Fri, 10 Feb 2006 10:18:15 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from wks05.rjo.embratel.net.br (wks05.rjo.embratel.net.br
	[200.255.253.239])
	by postgresql.org (Postfix) with ESMTP id A76469DCD91
	for <pgsql-admin@postgresql.org>; Fri, 10 Feb 2006 10:18:09 -0400 (AST)
Received: from SUPGR11 (supgr09.uni.embratel.net.br [10.4.22.18])
	by wks05.rjo.embratel.net.br (Postfix) with SMTP
	id 7731A1080B; Fri, 10 Feb 2006 12:18:13 -0200 (EDT)
Message-ID: <001901c62e55$4f8b87c0$1216040a@SUPGR11>
From: "Marcos de Lima Takayas" <takayas@embratel.net.br>
To: "Stef" <stefan.vanderberg@ucs-software.co.za>
Cc: <pgsql-admin@postgresql.org>
References: 
 <425e0fb833fad@wp.pl><d4c7t1$167u$1@news.hub.org><09a501c62e4c$efb952d0$1216040a@SUPGR11>
	<20060210155443.55b7a984@svb.ucs.co.za>
Subject: Re: HELP
Date: Fri, 10 Feb 2006 12:18:56 -0300
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.411 required=5 tests=[AWL=0.411]
X-Spam-Score: 0.411
X-Spam-Level: 
X-Archive-Number: 200602/104
X-Sequence-Number: 20525

I copied Mr.Zé Carlos e-mail, because my problem is equal.
Postgres version = 8.1.2
Operating system = Slackware .
This is really critical for me.
I found a possible solution => 
http://archives.postgresql.org/pgsql-patches/2005-02/msg00124.php

thank you
----- Original Message ----- 
From: "Stef" <stefan.vanderberg@ucs-software.co.za>
To: "Marcos de Lima Takayas" <takayas@embratel.net.br>
Cc: <pgsql-admin@postgresql.org>
Sent: Friday, February 10, 2006 10:54 AM
Subject: Re: [ADMIN] HELP


Marcos de Lima Takayas mentioned :
=> We had an accident with a table where all tuples where deleted.
=> We have not run VACUUM yet and it seems like the datas are in place
=> in the base directory.
=> Our backup were not active when this happened.
=> I have seen some talk (Mr.Zé Carlos) about that it is possible to restore
=> those missing
=> data in this case, but I have not yet seen a solution for it.
=> Can anyone please help with this problem, it is kind of critical for us.

When this message was sent a year ago, it also didn't mention the
postgres version or the operating system. Is this _really_ that critical
for you? :
http://archives.postgresql.org/pgsql-admin/2004-07/msg00209.php