Re: Postgres startup - Mailing list pgsql-novice

From Tom Lane
Subject Re: Postgres startup
Date
Msg-id 7242.1113284045@sss.pgh.pa.us
Whole thread Raw
In response to Postgres startup  (Andy Dunlop <andy@infocus.co.za>)
List pgsql-novice
Andy Dunlop <andy@infocus.co.za> writes:
> DEBUG:  database system shutdown was interrupted at 2005-04-11 16:09:06 SAST
> DEBUG:  ReadRecord: invalid resource manager id 155 at 0/766DB9C
> DEBUG:  invalid primary checkpoint record
> DEBUG:  ReadRecord: invalid resource manager id 159 at 0/766DB5C
> DEBUG:  invalid secondary checkpoint record
> FATAL 2:  unable to locate a valid checkpoint record

Ugh :-(

> Is there any way to get the db running?

See pg_resetxlog, and be suitably untrusting of the consistency of your
data until you've cross-checked as much as you can.

After you get out of the woods, consider updating to some newer version
of Postgres ... we haven't emitted "FATAL 2" in quite some time ...

            regards, tom lane

pgsql-novice by date:

Previous
From: stig erikson
Date:
Subject: Re: what is command to view data inside the table
Next
From: David Orme
Date:
Subject: select top N entries from several groups