Re: Missing pg_clog files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Carol Walter <walterc(at)indiana(dot)edu>
Cc: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Missing pg_clog files
Date: 2008-09-24 15:44:22
Message-ID: 4913.1222271062@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Carol Walter <walterc(at)indiana(dot)edu> writes:
> Are the files that contain the hex characters supposed to contain a
> single string and no control characters?

Yes, you want 256K occurrences of the byte value 0x55 and nothing else.

> I'm also wondering if, after I create the dummy files, and pg_dump
> works, I could restore an old pg_dumpall file and then insert any
> data that aren't there from the pg_dumps.

It'd be a good idea to do as much cross-checking as you can, since
it's highly probable that the dumped data will be at least partly wrong.

No, I'm afraid updating to 8.2.latest won't get you out of this.
It might possibly prevent a recurrence.

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-09-24 15:53:37 Re: Missing pg_clog files
Previous Message Carol Walter 2008-09-24 14:31:05 Re: Missing pg_clog files