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