Re: how to recover after harddisk error
От | Peter Alberer |
---|---|
Тема | Re: how to recover after harddisk error |
Дата | |
Msg-id | 000101c2dd7f$69cf65e0$5be0d089@ekelhardt обсуждение исходный текст |
Ответ на | Re: how to recover after harddisk error (Björn Metzdorf <bm@turtle-entertainment.de>) |
Список | pgsql-general |
Thanks a lot Bjoern. Just wanted to mention that I found pg_resetxlog to be available per default in pg7.3.2. >-----Ursprüngliche Nachricht----- >Von: Björn Metzdorf [mailto:bm@turtle-entertainment.de] >Gesendet: Mittwoch, 26. Februar 2003 10:25 >An: Peter Alberer; pgsql-general@postgresql.org >Betreff: Re: [GENERAL] how to recover after harddisk error > >> 2003-02-26 09:03:06 [1291] DEBUG: invalid primary checkpoint record >> 2003-02-26 09:03:06 [1291] DEBUG: open of >> /usr/local/pgsql/data/pg_xlog/0000001A000000C8 (log file 26, segment >> 200) failed >> >> I did the following steps to get the system running again: >> >> - a new initdb in another data-directory >> - create the database again >> - restore the data from the last available nightly dump >> >> Is there a better way to get the system running again? Had there been >> any way to access the old system again? The steps I did took about 45 >> min which is quite long (cause the db-dump is rather large) and if there >> had been some important data it had been lost... > >pg_resetxlog from contrib > >Regards, >Bjoern
В списке pgsql-general по дате отправления: