| 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
| 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 |