Title: RE: [GENERAL] 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

Reply via email to