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 по дате отправления: