Postgres Pro
Downloads
Home   >   mailing lists

Re: Resume Incomplete Pg-restore - Mailing list pgsql-admin

From Craig Ringer
Subject Re: Resume Incomplete Pg-restore
Date
Msg-id 4EE944C0.4080404@ringerc.id.au
Whole thread Raw
In response to Resume Incomplete Pg-restore  (P R <user2037@live.com>)
List pgsql-admin
Tree view
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

pgsql-admin by date:

Previous
From: P R
Date:
Subject: Resume Incomplete Pg-restore
Next
From: Karuna Karpe
Date:
Subject: tablespace backup and recovery from or to remote machine