Re: Problems starting the database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Problems starting the database
Дата
Msg-id 29987.1047509191@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Problems starting the database  (gborges@radiumsystems.com.br)
Список pgsql-admin
gborges@radiumsystems.com.br writes:
> 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
Iused before). 

Did you forget to copy pg_xlog/ ?  Or did the kernel crash lose those files?

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

You can run pg_resetxlog, but you'll need to manually inspect your
dumped data to see if you have any partially-committed recent
transactions.

            regards, tom lane

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

Предыдущее
От: Robert Treat
Дата:
Сообщение: Re: Help with determining a database's size
Следующее
От: Tom Lane
Дата:
Сообщение: Re: I cannot get the db to initialize. Please help.