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!!!
|
Список | 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 по дате отправления: