Re: how to use pg_resetxlog

--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