Re: how to use pg_resetxlog

Поиск
Список
Период
Сортировка
От Johnson, Shaunn
Тема Re: how to use pg_resetxlog
Дата
Msg-id 73309C2FDD95D11192E60008C7B1D5BB05FEDACC@snt452.corp.bcbsm.com
обсуждение исходный текст
Ответ на how to use pg_resetxlog  ("Johnson, Shaunn" <SJohnson6@bcbsm.com>)
Ответы Re: how to use pg_resetxlog
Список 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 по дате отправления:

Предыдущее
От: Shridhar Daithankar
Дата:
Сообщение: Re: Recomended FS
Следующее
От: "Markus Wollny"
Дата:
Сообщение: Re: Recomended FS