Re: after using pg_resetxlog, db lost

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: after using pg_resetxlog, db lost
Дата
Msg-id 20040601135333.GA26302@dcc.uchile.cl
обсуждение исходный текст
Ответ на Re: after using pg_resetxlog, db lost  (zhicheng wang <wang_zc@yahoo.co.uk>)
Список pgsql-general
On Tue, Jun 01, 2004 at 02:43:03PM +0100, zhicheng wang wrote:
> hi, thanks
>
> rhdb is the postgresql for redhat ELAS3
>
> it could not start and the error is attached

Your database seems completely busted.  Are you running with fsync off?
IDE drives with write caching enabled?  NFS or some other weirdness?

What was your procedure to shut the server down anyway?  Any normal
procedure should have terminated the Postgres processes before closing
shop, althought failing to do so does not normally corrupt databases.

I assume Redhat did not produce an unreliable Postgres version!

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Postgres is bloatware by design: it was built to house
PhD theses." (Joey Hellerstein, SIGMOD annual conference 2002)


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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: Running Totals and other stuff....
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: book for postgresql