Re: Possibly corrupted pg_control file after machine crash

Michael Wood <esiotrot@gmail.com> writes:
> A VM of mine running PostgreSQL 8.3 (from Ubuntu 8.10) died a couple
> of nights ago.  It was not doing anything at the time, and the
> database was on an external (NAS) volume using ext3.  When I set up a
> new VM with Ubuntu 8.10 and attached the external volume to it, fsck
> replayed the journal but was otherwise happy.  I ran fsck with the -f
> option after that just to make sure and it reported no problems.

> Now if I run pg_controldata it complains about the CRC not being
> correct on pg_control.

Are you using the exact same PG executables that you used before?
These symptoms look quite a lot like a previous report that turned
out to be due to rebuilding PG with a different size for time_t.

            regards, tom lane