Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0C50064FC29 for ; Wed, 24 Sep 2008 08:13:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 79489-03 for ; Wed, 24 Sep 2008 08:13:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from belushi.uits.indiana.edu (belushi.uits.indiana.edu [129.79.1.188]) by postgresql.org (Postfix) with ESMTP id D643364FC25 for ; Wed, 24 Sep 2008 08:13:12 -0300 (ADT) Received: from spinner.uits.indiana.edu (spinner.uits.indiana.edu [129.79.1.139]) by belushi.uits.indiana.edu (8.14.2/8.13.8/IU Messaging Team) with ESMTP id m8OBD8Ns016751; Wed, 24 Sep 2008 07:13:09 -0400 Received: from localhost (spinner.uits.indiana.edu [127.0.0.1]) by spinner.uits.indiana.edu (Postfix) with ESMTP id E1446101B3; Wed, 24 Sep 2008 07:13:08 -0400 (EDT) Received: from ppp-68-72-59-148.dsl.bltnin.ameritech.net (ppp-68-72-59-148.dsl.bltnin.ameritech.net [68.72.59.148]) by webmail.iu.edu (Horde MIME library) with HTTP; Wed, 24 Sep 2008 07:13:08 -0400 Message-ID: <20080924071308.8lficujqsck8w44w@webmail.iu.edu> Date: Wed, 24 Sep 2008 07:13:08 -0400 From: "Walter, Carol Williams" To: Scott Marlowe Cc: Tena Sakai , pgsql-admin@postgresql.org Subject: Re: Missing pg_clog files References: <1B5F9FC4-578A-44FA-8264-FC674CF5A0FD@indiana.edu> <20080923215948.m743u3mtcwg88s4o@webmail.iu.edu> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format="flowed" Content-Disposition: inline Content-Transfer-Encoding: 7bit User-Agent: Internet Messaging Program (IMP) H3 (4.0.4) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200809/275 X-Sequence-Number: 30368 Hello, I will try this. Is there a particular size these files need to be? Then I can try the pg_dumpall. That's, of course, my main concern. I need to get the data out. By the way, before I went to panic mode, I tried pg_dumpall and reindexing the database. Everything gets the same error, perhaps with a different file name. Carol Quoting Scott Marlowe : > On Tue, Sep 23, 2008 at 10:16 PM, Tena Sakai wrote: >> Hi Carol, >> >> I detect in you some apprehension as to pg_dumpall >> won't run or complete. Why is that? Have you already >> done it and it didn't work? If that's not the case, >> why not run pg_dumpall at a quiet hour and see? >> >> I think Scott is right as to install the latest >> 8.2 on top. It won't be time consuming task. >> Why not give it a wheel? It would be good to >> find out one way or the other. >> >> >> Scott: Are files 0000 through 002F (which are >> not there) absolutely necessary for recovering data? > > Most likely not. If the db won't start up without them, it might be > possible to create new clog files that are nothing but zeroes. Never > been in this position though... > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin >