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 F2D2E52C6B for ; Wed, 27 Jul 2005 12:16:09 -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 79723-05 for ; Wed, 27 Jul 2005 15:16:00 +0000 (GMT) Received: from trendinterscan.pnp.co.za (unknown [196.7.24.196]) by svr1.postgresql.org (Postfix) with ESMTP id 7152F52C5D for ; Wed, 27 Jul 2005 12:15:57 -0300 (ADT) Received: by pnp.co.za (8.9.3+Sun/8.9.3) with ESMTP id RAA12253for ; Wed, 27 Jul 2005 17:15:49 +0200 (SAST) Received: from 164.101.15.103 (unknown [164.101.15.103])by scorenet.score.pnp.co.za (Postfix) with ESMTP id 29385FF9for ; Wed, 27 Jul 2005 17:11:18 +0200 (SAST) Subject: Re: Database disappeared From: Marco Rademeyer To: pgsql-admin@postgresql.org In-Reply-To: <25685.1122474185@sss.pgh.pa.us> References: <800FF6DB85F96B488D9CD739A651C5B503881230@ucidcw.uci.cu> <20050726172703.GE14882@alvh.no-ip.org> <1122457800.19198.53.camel@localhost.localdomain> <25685.1122474185@sss.pgh.pa.us> Content-Type: text/plain Date: Wed, 27 Jul 2005 17:12:21 +0200 Message-Id: <1122477142.4918.67.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.0.2 Content-Transfer-Encoding: 7bit X-imss-version: 2.028 X-imss-result: Passed X-imss-scores: Clean:99.90000 C:2 M:3 S:5 R:5 X-imss-settings: Baseline:4 C:4 M:4 S:3 R:4 (1.0000 1.0000) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.394 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_WHOIS X-Spam-Level: X-Archive-Number: 200507/223 X-Sequence-Number: 18279 hi All I seems to be that the script that I was running to do the VACUUM FULL on the databases was not doing its job. I have run a VACUUM FREEZ on the databases. This has brought back some of the Databases. I am waiting for it to complete. I was getting warparound errors. When I tried to do a vacuum. Thanks for the VACUUM idea. I thought it was happening every Sunday. Thanks for the help. Regards Marco On Wed, 2005-07-27 at 10:23 -0400, Tom Lane wrote: > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend > > !DSPAM:42e79f14190891268238603! > > > Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? > If you don't have web access, the disclaimer can be mailed to you on request. > Disclaimer requests to be sent to it-security@pnp.co.za > Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be sent to it-security@pnp.co.za