pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Resume Incomplete Pg-restore
2+ messages / 2 participants
[nested] [flat]

* Resume Incomplete Pg-restore
@ 2011-12-14 18:52  P R <user2037@live.com>
  0 siblings, 1 reply; 2+ messages in thread

From: P R @ 2011-12-14 18:52 UTC (permalink / raw)
  To: pgsql-admin


Is there any way to resume an incomplete Pg-restore from a custom Pgdump file?
 		 	   		  =

^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Resume Incomplete Pg-restore
@ 2011-12-15 00:52  Craig Ringer <ringerc@ringerc.id.au>
  parent: P R <user2037@live.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Craig Ringer @ 2011-12-15 00:52 UTC (permalink / raw)
  To: P R <user2037@live.com>; +Cc: 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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2011-12-15 00:52 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-12-14 18:52 Resume Incomplete Pg-restore P R <user2037@live.com>
2011-12-15 00:52 ` Craig Ringer <ringerc@ringerc.id.au>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox