Re: Possibly corrupted pg_control file after machine crash - Mailing list pgsql-novice

From Tom Lane
Subject Re: Possibly corrupted pg_control file after machine crash
Date
Msg-id 448.1246629333@sss.pgh.pa.us
Whole thread Raw
In response to Possibly corrupted pg_control file after machine crash  (Michael Wood <esiotrot@gmail.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Doug Graham
Date:
Subject: Setting shmmax in /etc/rc on Mac OS X to install Postgres
Next
From: Doug Graham
Date:
Subject: Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres