pg_restore recovery from error.

Поиск
Список
Период
Сортировка
От Chris Bowlby
Тема pg_restore recovery from error.
Дата
Msg-id 6.1.0.6.2.20040615135106.026093e0@pop.accesswave.ca
обсуждение исходный текст
Ответы Re: pg_restore recovery from error.  ("V i s h a l Kashyap @ [Sai Hertz And Control Systems]" <sank89@sancharnet.in>)
Re: pg_restore recovery from error.  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: pg_restore recovery from error.  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Hi All,
 I've been attempting to recover some data from a data file that was 
dumped and compressed using pg_dump. I've noticed that the pg_restore 
application was supposed to have some work put into place to help it 
continue of it ran into an error, but I've run into an issue here it is not 
continuing past an error that I'm getting:

pg_restore: restoring data for table "test_opens"
pg_restore: restoring data for table "test_unsubs"
pg_restore: [custom archiver] could not read data block -- expected 4096, 
got 3870
pg_restore: *** aborted because of error
 It appears some of the data itself is not readable, which is fine, but 
I'd like it to skip past this table and move onto the next one. Has anyone 
got any ideas as to where I should look for that?




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

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: #postgresql report
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: #postgresql report