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 B5C3C9DC844 for ; Fri, 10 Feb 2006 09:55:03 -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 85153-05 for ; Fri, 10 Feb 2006 09:55:07 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 527429DC80D for ; Fri, 10 Feb 2006 09:55:01 -0400 (AST) Received: from ucsns.ucs.co.za (ucsns.ucs.co.za [196.23.43.2]) by svr4.postgresql.org (Postfix) with ESMTP id B73C65AF83B for ; Fri, 10 Feb 2006 13:55:04 +0000 (GMT) Received: from ucspost.ucs.co.za (ucspost.ucs.co.za [196.23.43.3]) by ucsns.ucs.co.za (Postfix) with ESMTP id 3F5C52BDB5; Fri, 10 Feb 2006 15:54:43 +0200 (SAST) Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3]) by ucspost.ucs.co.za (Postfix) with ESMTP id 20968DBDE5; Fri, 10 Feb 2006 15:54:43 +0200 (SAST) Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148]) by jhb.ucs.co.za (Postfix) with ESMTP id 206FB97C3B; Fri, 10 Feb 2006 15:54:43 +0200 (SAST) Date: Fri, 10 Feb 2006 15:54:43 +0200 From: Stef To: "Marcos de Lima Takayas" Cc: Subject: Re: HELP Message-ID: <20060210155443.55b7a984@svb.ucs.co.za> In-Reply-To: <09a501c62e4c$efb952d0$1216040a@SUPGR11> References: <425e0fb833fad@wp.pl> <09a501c62e4c$efb952d0$1216040a@SUPGR11> X-Mailer: Sylpheed-Claws 1.9.6cvs1 (GTK+ 2.8.10; i486-pc-linux-gnu) User-Agent: sillypheed-claws (anti-aliased) X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YEWH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@ X-Operating-System: sid X-X-X: _-^-_ Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200602/138 X-Sequence-Number: 20559 Marcos de Lima Takayas mentioned : =3D> We had an accident with a table where all tuples where deleted. =3D> We have not run VACUUM yet and it seems like the datas are in place =3D> in the base directory. =3D> Our backup were not active when this happened. =3D> I have seen some talk (Mr.Z=E9 Carlos) about that it is possible to re= store=20 =3D> those missing =3D> data in this case, but I have not yet seen a solution for it. =3D> Can anyone please help with this problem, it is kind of critical for u= s. When this message was sent a year ago, it also didn't mention the=20 postgres version or the operating system. Is this _really_ that critical=20 for you? : http://archives.postgresql.org/pgsql-admin/2004-07/msg00209.php