Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 4ED3C64FC24
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 24 Sep 2008 12:44:43 -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 43074-03 for <pgsql-admin-postgresql.org@postgresql.org>;
	Wed, 24 Sep 2008 12:44:28 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130])
	by postgresql.org (Postfix) with ESMTP id 3073564FC1E
	for <pgsql-admin@postgresql.org>; Wed, 24 Sep 2008 12:44:27 -0300 (ADT)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m8OFiM4d004914;
	Wed, 24 Sep 2008 11:44:22 -0400 (EDT)
To: Carol Walter <walterc@indiana.edu>
cc: Scott Marlowe <scott.marlowe@gmail.com>,
	Tena Sakai <tsakai@gallo.ucsf.edu>, pgsql-admin@postgresql.org
Subject: Re: Missing pg_clog files 
In-reply-to: <FE8FD34C-4516-425A-B7AD-1917F134320F@indiana.edu> 
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>
	<20080924071308.8lficujqsck8w44w@webmail.iu.edu>
	<052D4170-A065-4DDB-9F9D-6318E42C23BA@indiana.edu>
	<29313.1222261821@sss.pgh.pa.us>
	<FE8FD34C-4516-425A-B7AD-1917F134320F@indiana.edu>
Comments: In-reply-to Carol Walter <walterc@indiana.edu>
	message dated "Wed, 24 Sep 2008 10:31:05 -0400"
Date: Wed, 24 Sep 2008 11:44:22 -0400
Message-ID: <4913.1222271062@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none
X-Spam-Level: 
X-Archive-Number: 200809/281
X-Sequence-Number: 30374

Carol Walter <walterc@indiana.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