Re: how to use pg_resetxlog - Mailing list pgsql-general

From Johnson, Shaunn
Subject Re: how to use pg_resetxlog
Date
Msg-id 73309C2FDD95D11192E60008C7B1D5BB05FEDACC@snt452.corp.bcbsm.com
Whole thread Raw
In response to how to use pg_resetxlog  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Responses Re: how to use pg_resetxlog
List pgsql-general

--Thanks to all that replied

--I did the pg_resetxlog -f $PGDATA and
--it generated a new log, but when I try to
--restart the database, it fails.  I look in the
--logs and I see:

[snip]
Oct 21 01:32:13 localsvr postgres[2598]: [1] FATAL 2: 
control file context is broken
Oct 21 01:32:14 localsvr postgresql: Starting postgresql
service:  failed
[/snip]

--There doesn't seem to be much info in groups.google.com
--about this message.  What does this mean and how can
--I fix the DB (so I can dump it into a new version)?

--Thanks!

[snip from past email]
This past weekend, the RAID array took a hit and crashed
the database.  I get a few errors like:
[snip]
DEBUG:  invalid secondary checkpoint record
FATAL 2:  unable to locate a valid checkpoint record
DEBUG:  proc_exit(2)
DEBUG:  shmem_exit(2)
DEBUG:  exit(2)
DEBUG:  reaping dead processes
DEBUG:  startup process (pid 23543) exited with exit code 2
DEBUG:  aborting startup due to startup process failure
[/snip]

[/snip from past email]

-X

pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Recomended FS
Next
From: "Markus Wollny"
Date:
Subject: Re: Recomended FS