How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory

Поиск
Список
Период
Сортировка
От peter Willis
Тема How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory
Дата
Msg-id 41741425.4070509@borstad.com
обсуждение исходный текст
Ответы Re: How do I recover from>> pg_xlog/0000000000000000 (log file 0, segment 0) failed: No such file or directory  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello,

Is there a way to recover from the following error?
I have (had) an existing database and wish not
to lose the data tables.

Thanks for any help,

Pete


[postgres@web2 /]$ pg_ctl start
postmaster successfully started
[postgres@web2 /]$ LOG:  database system shutdown was interrupted at
2004-10-18 11:41:55 PDT
LOG:  open of /web2-disk1/grip/database/pg_xlog/0000000000000000 (log
file 0, segment 0) failed: No such file or directory
LOG:  invalid primary checkpoint record
LOG:  open of /web2-disk1/grip/database/pg_xlog/0000000000000000 (log
file 0, segment 0) failed: No such file or directory
LOG:  invalid secondary checkpoint record
PANIC:  unable to locate a valid checkpoint record
LOG:  startup process (pid 2803) was terminated by signal 6
LOG:  aborting startup due to startup process failure

[postgres@web2 /]$



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

Предыдущее
От: Scott Frankel
Дата:
Сообщение: attn.: psycopg users -- simple question
Следующее
От: Björn Lundin
Дата:
Сообщение: Re: Online & update races