Problems starting the database

Поиск
Список
Период
Сортировка
От gborges@radiumsystems.com.br
Тема Problems starting the database
Дата
Msg-id 20030310213657.D80C76C31F@smtp.radiumsystems.com.br
обсуждение исходный текст
Ответы Re: Problems starting the database  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi!

A kernel panic ocurred with my machine.

So, I have to recover my postgresql data directory. I copy the data directory to a new instalation (same version that I
usedbefore). 

When I try to start the message below appers in my log file.

DEBUG:  database system was interrupted at 2003-03-05 23:28:13 BRT
DEBUG:  open of /var/lib/pgsql/data/pg_xlog/00000000000000DE (log file 0, segment 222) failed: No such file or
directory
DEBUG:  invalid primary checkpoint record
DEBUG:  open of /var/lib/pgsql/data/pg_xlog/00000000000000DE (log file 0, segment 222) failed: No such file or
directory
DEBUG:  invalid secondary checkpoint record
FATAL 2:  unable to locate a valid checkpoint record
DEBUG:  startup process (pid 8370) exited with exit code 2
DEBUG:  aborting startup due to startup process failure

There is some way to ignore this problem and start the postgres? I only want to start the database to do a pg_dump.

Thnks a lot.
Gustavo B. Oliveira
RadiumSystems.com

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

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: multiple $PGDATA dir's for one! postmaster?
Следующее
От: "Yudha Setiawan"
Дата:
Сообщение: OOT-Does PostgreSQL has commercial level.