Re: Recovery of PGSQL after system crash failing!!!

Поиск
Список
Период
Сортировка
От Vadim Mikheev
Тема Re: Recovery of PGSQL after system crash failing!!!
Дата
Msg-id 001101c094a7$c73a2620$4a79583f@sectorbase.com
обсуждение исходный текст
Ответ на Recovery of PGSQL after system crash failing!!!  (Ryan Kirkpatrick <pgsql@rkirkpat.net>)
Ответы Re: Recovery of PGSQL after system crash failing!!!  (Ryan Kirkpatrick <pgsql@rkirkpat.net>)
Список pgsql-hackers
> DEBUG: starting up
> DEBUG: database system was interrupted at 2001-02-11 04:08:12
> DEBUG: Checkpoint record at (0, 805076492)
> postmaster: reaping dead processes...
> Startup failed - abort
> 
> And that is it, from running 'postmaster -D /usr/local/pgsql/data/'. I get
> the same thing each time I run it. I assume that WAL is for some reason
> failing to restore/recover the database. 
> The system is a stock Debian 2.2 system, Dual PPro200, w/pgsql
> 7.1beta4. The system crash occured during the nightly update of the
> databases (from another, internal, non-pgsql, database system). Is there
> anyway to recover the database, or do I need to do a 'rm -rf

Please try to restart with option wal_debug = 1 so postmaster log
will be more informative and send this log me.

> data; initdb'? A quick response would be greatly appreciated. Thanks.

Please archieve PG' data dir - it probably will be useful to find bug.

Vadim




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

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: ODBC backward versions
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: 7.0.3 spelling error