Re: production server down
От | Joe Conway |
---|---|
Тема | Re: production server down |
Дата | |
Msg-id | 41C06CB3.6010107@joeconway.com обсуждение исходный текст |
Ответ на | Re: production server down (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: production server down
|
Список | pgsql-hackers |
Tom Lane wrote: > My advice is to backup the $PGDATA tree (which you said was in > progress), then pg_resetxlog, then cross-check the hell out of the data > you see. Only if you can detect some data problems can we guess at > something else to do ... > Before running pg_resetxlog, a couple of questions: 1. Since it appears that pg_control is suspect, should I force it to be rebuilt, and if so, how? 2. At the end of GuessControlValues is this comment: /* * XXX eventually, should try to grovel through old XLOG to develop * more accurate values for startupid, nextXID, and nextOID. */ What would be involved in doing this, and doyou think it would be worth it? Thanks, Joe
В списке pgsql-hackers по дате отправления: