Re: Possibly corrupted pg_control file after machine crash

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Possibly corrupted pg_control file after machine crash
Дата
Msg-id 407d949e0907030526x264f07b8td4cd8858c6cd4a49@mail.gmail.com
обсуждение исходный текст
Ответ на Possibly corrupted pg_control file after machine crash  (Michael Wood <esiotrot@gmail.com>)
Список pgsql-novice
At least the following fields seem to be garbage:

On Fri, Jul 3, 2009 at 12:32 PM, Michael Wood<esiotrot@gmail.com> wrote:
> Maximum data alignment:               0
> Database block size:                  8
> Blocks per segment of large relation: 0
> WAL block size:                       0
> Bytes per WAL segment:                1093850759
> Maximum length of identifiers:        8192
> Maximum columns in an index:          131072
> Maximum size of a TOAST chunk:        8192
> Date/time type storage:               64-bit integers
> Maximum length of locale name:        64
> LC_COLLATE:
> LC_CTYPE:


One option might be to initdb a new database, grab the control file
from there, use pg_resetxlog to restore the important values from your
old control file and then see if you can pick up from there.

--
greg
http://mit.edu/~gsstark/resume.pdf

В списке pgsql-novice по дате отправления:

Предыдущее
От: Michael Wood
Дата:
Сообщение: Possibly corrupted pg_control file after machine crash
Следующее
От: Doug Graham
Дата:
Сообщение: Setting shmmax in /etc/rc on Mac OS X to install Postgres