Re: Possibly corrupted pg_control file after machine crash

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Wood <esiotrot(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Possibly corrupted pg_control file after machine crash
Date: 2009-07-03 13:55:33
Message-ID: 448.1246629333@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Michael Wood <esiotrot(at)gmail(dot)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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Doug Graham 2009-07-03 14:43:16 Re: Setting shmmax in /etc/rc on Mac OS X to install Postgres
Previous Message Doug Graham 2009-07-03 13:47:21 Setting shmmax in /etc/rc on Mac OS X to install Postgres