pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Walter, Carol Williams <walterc@indiana.edu>
To: Scott Marlowe <scott.marlowe@gmail.com>
Cc: Tena Sakai <tsakai@gallo.ucsf.edu>
Cc: pgsql-admin@postgresql.org
Subject: Re: Missing pg_clog files
Date: Wed, 24 Sep 2008 07:13:08 -0400
Message-ID: <20080924071308.8lficujqsck8w44w@webmail.iu.edu> (raw)
In-Reply-To: <dcc563d10809232121y47e27c32u94effea9809e494d@mail.gmail.com>
References: <CA701605-BE56-416C-9034-789B20180281@indiana.edu>
	<FE44E0D7EAD2ED4BB2165071DB8E328C0378F509@egcrc-ex01.egcrc.org>
	<1B5F9FC4-578A-44FA-8264-FC674CF5A0FD@indiana.edu>
	<dcc563d10809231656xe8d199eh3093f959e88cc7de@mail.gmail.com>
	<FE44E0D7EAD2ED4BB2165071DB8E328C0378F50E@egcrc-ex01.egcrc.org>
	<20080923215948.m743u3mtcwg88s4o@webmail.iu.edu>
	<dcc563d10809232005i533433d9xde8f515f0f382c26@mail.gmail.com>
	<E22168D9-DDAD-4EE0-8CB9-8CA79FB26721@indiana.edu>
	<FE44E0D7EAD2ED4BB2165071DB8E328C0378F512@egcrc-ex01.egcrc.org>
	<dcc563d10809232121y47e27c32u94effea9809e494d@mail.gmail.com>

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 <scott.marlowe@gmail.com>:

> On Tue, Sep 23, 2008 at 10:16 PM, Tena Sakai <tsakai@gallo.ucsf.edu> 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
>






view thread (20+ messages)  latest in thread

Message-ID: <20080924071308.8lficujqsck8w44w@webmail.iu.edu>
Permalink:  ../20080924071308.8lficujqsck8w44w@webmail.iu.edu/
Also on:    postgresql.org/message-id/20080924071308.8lficujqsck8w44w@webmail.iu.edu

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: walterc@indiana.edu, scott.marlowe@gmail.com, tsakai@gallo.ucsf.edu
  Subject: Re: Missing pg_clog files
  In-Reply-To: <20080924071308.8lficujqsck8w44w@webmail.iu.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox