Re: Resume Incomplete Pg-restore

From: Craig Ringer <ringerc(at)ringerc(dot)id(dot)au>
To: P R <user2037(at)live(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Resume Incomplete Pg-restore
Date: 2011-12-15 00:52:16
Message-ID: 4EE944C0.4080404@ringerc.id.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 12/15/2011 02:52 AM, P R wrote:
> Is there any way to resume an incomplete Pg-restore from a custom
> Pgdump file?

Not reliably.

If you know it failed or stopped at a particular defined point, you
might be able to selectively restore table-by-table from there, but that
won't work if you have any circular references.

--
Craig Ringer

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Brian Mutinda 2011-12-15 05:44:37 PostgreSql Startup Error
Previous Message P R 2011-12-14 18:52:13 Resume Incomplete Pg-restore