Received: from cncware.whidbey.com (IDENT:ken@cncware.whidbey.com [209.166.83.37]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA89122 for ; Sun, 7 May 2000 14:49:33 -0400 (EDT) (envelope-from ken@cncware.whidbey.com) Received: from localhost (localhost [[UNIX: localhost]]) by cncware.whidbey.com (8.9.3/8.9.3) id LAA31913; Sun, 7 May 2000 11:52:13 -0700 From: "Ken J. Wright" Reply-To: "Ken J. Wright" Organization: Cncware To: "Oscar Serrano" , Subject: Re: postgres crash. HELP Date: Sun, 7 May 2000 11:48:34 -0700 X-Mailer: KMail [version 1.0.20] Content-Type: text/plain References: MIME-Version: 1.0 Message-Id: <00050711521300.31898@cncware.whidbey.com> Content-Transfer-Encoding: 8bit X-Archive-Number: 200005/68 On Fri, 05 May 2000, Oscar Serrano wrote: > Hi: > I don't know how, but Postgres has made a very odd thing. > Suddenly in the directory where I have all the tables, now there is about > 1000 files with names like this: > > pg_class_oid_index.165 pg_class_oid_index.2835 > pg_class_oid_index.1650 pg_class_oid_index.2836 I had the same problem at a site with 6.5.0. Although postgres did not crash, it did suck up a lot of disk space. After upgrading to 6.5.3 and doing initdb with a good backup the problem appears to have been fixed. Ken