X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id E1E6252C11 for ; Wed, 27 Jul 2005 11:24:47 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66340-05 for ; Wed, 27 Jul 2005 14:24:44 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 303D752BBF for ; Wed, 27 Jul 2005 11:24:43 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j6REN5jH025686; Wed, 27 Jul 2005 10:23:06 -0400 (EDT) To: Marco Rademeyer Cc: pgsql-admin@postgresql.org Subject: Re: Database disappeared In-reply-to: <1122457800.19198.53.camel@localhost.localdomain> References: <800FF6DB85F96B488D9CD739A651C5B503881230@ucidcw.uci.cu> <20050726172703.GE14882@alvh.no-ip.org> <1122457800.19198.53.camel@localhost.localdomain> Comments: In-reply-to Marco Rademeyer message dated "Wed, 27 Jul 2005 11:49:59 +0200" Date: Wed, 27 Jul 2005 10:23:05 -0400 Message-ID: <25685.1122474185@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200507/220 X-Sequence-Number: 18276 Marco Rademeyer writes: > I have a very strange problem. > I was importing about 5 gigs of data last night. > When I got in this morning the script had completed. But my database has > disappeared. I login to the databases , but all the tables are gone. Sounds a whole lot like transaction ID wraparound :-(. How long ago did you last do a database-wide VACUUM? regards, tom lane