| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andy Dunlop <andy(at)infocus(dot)co(dot)za> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Postgres startup |
| Date: | 2005-04-12 05:34:05 |
| Message-ID: | 7242.1113284045@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Andy Dunlop <andy(at)infocus(dot)co(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Orme | 2005-04-12 11:21:29 | select top N entries from several groups |
| Previous Message | Tom Lane | 2005-04-11 16:37:28 | Re: Simple function closes connection to server |