Re: pg_restore recovery from error.

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

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2004-06-15 20:52:02 PITR Recovery
Previous Message Chris Bowlby 2004-06-15 19:58:51 Re: pg_restore recovery from error.