Re: pg_restore recovery from error.

From: Chris Bowlby <chris(at)pgsql(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_restore recovery from error.
Date: 2004-06-15 23:02:21
Message-ID: 6.1.0.6.2.20040615200127.02464c10@mail.pgsql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

In that table I'm pretty sure there are no other records, but I'm hoping
there are some records for the tables stored after that particular table..

At 05:48 PM 6/15/2004, Tom Lane wrote:
>Chris Bowlby <chris(at)pgsql(dot)com> writes:
> > 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?
>
>You sure there is a next one? This sounds more like a truncated dump file
>than anything else ...
>
> regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Doug McNaught 2004-06-15 23:18:18 Re: initdb initial password
Previous Message Andrew Dunstan 2004-06-15 22:39:51 Re: initdb initial password