Re: Possibly corrupted pg_control file after machine crash

At least the following fields seem to be garbage:

On Fri, Jul 3, 2009 at 12:32 PM, Michael Wood<esiotrot(at)gmail(dot)com> wrote:
> Maximum data alignment:               0
> Database block size:                  8
> Blocks per segment of large relation: 0
> WAL block size:                       0
> Bytes per WAL segment:                1093850759
> Maximum length of identifiers:        8192
> Maximum columns in an index:          131072
> Maximum size of a TOAST chunk:        8192
> Date/time type storage:               64-bit integers
> Maximum length of locale name:        64
> LC_COLLATE:
> LC_CTYPE:

One option might be to initdb a new database, grab the control file
from there, use pg_resetxlog to restore the important values from your
old control file and then see if you can pick up from there.

--
greg
http://mit.edu/~gsstark/resume.pdf