recovering a control file from a shutdown database....

From: Jerry Asher <jerry(at)theashergroup(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: recovering a control file from a shutdown database....
Date: 2001-09-04 23:37:48
Message-ID: 4.3.2.7.2.20010904163235.00c7a330@hollyjerry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Somehow in upgrading from 7.1.2 to 7.1.3 (and with much operator error
along the way), my database became corrupted.

I believe it is only the pg_control file that was damaged.

The database was completely shutdown at the time.

Is there anyway to create a new pg_control file, based on the contents of
the database itself?

The symptoms are that the

data/global/1262 file has a file size of 8192 bytes and a time stamp of
last June.
data/global/pg_control has a file size of 16384 bytes and a time stamp of
today.

When the postmaster starts up, it tells me that:

database was initialized with BLCKSZ 16384,
but the backend was compiled with BLCKSZ 8192.
looks like you need an initdb.

Bleh! I would prefer to not waste my db, and I assume initdb will do just
that.

Can anything be done to recover the pg_control file?

Thanks,

Jerry
========================================================
Jerry Asher jerry(at)theashergroup(dot)com
1678 Shattuck Avenue Suite 161 Tel: (510) 549-2980
Berkeley, CA 94709 Fax: (877) 311-8688

Responses

Browse pgsql-general by date

  From Date Subject
Next Message will trillich 2001-09-05 02:21:42 Re: Indexes
Previous Message Ryan Mahoney 2001-09-04 23:34:25 Re: Index usage question