Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 1B0C6311517
	for <pgsql-admin@postgresql.org>; Wed, 14 Dec 2011 20:52:37 -0400 (AST)
Received: from mail-ww0-f42.google.com ([74.125.82.42])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1RazYq-0005JV-64
	for pgsql-admin@postgresql.org; Thu, 15 Dec 2011 00:52:36 +0000
Received: by wgbds13 with SMTP id ds13so15013wgb.1
	for <pgsql-admin@postgresql.org>; Wed, 14 Dec 2011 16:52:23 -0800 (PST)
Received: by 10.180.19.68 with SMTP id c4mr1388104wie.32.1323910342991;
	Wed, 14 Dec 2011 16:52:22 -0800 (PST)
Received: from ayaki.localdomain (124-169-254-28.dyn.iinet.net.au.
	[124.169.254.28])
	by mx.google.com with ESMTPS id en20sm6026496wid.10.2011.12.14.16.52.19
	(version=SSLv3 cipher=OTHER); Wed, 14 Dec 2011 16:52:21 -0800 (PST)
Message-ID: <4EE944C0.4080404@ringerc.id.au>
Date: Thu, 15 Dec 2011 08:52:16 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:7.0.1) Gecko/20110930 Thunderbird/7.0.1
MIME-Version: 1.0
To: P R <user2037@live.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Resume Incomplete Pg-restore
References: <BAY157-W221EC85F1F073C983A2623B4A20@phx.gbl>
In-Reply-To: <BAY157-W221EC85F1F073C983A2623B4A20@phx.gbl>
Content-Type: multipart/alternative;
	boundary="------------000602030803050005010402"
X-Pg-Spam-Score: -1.2 (-)
X-Archive-Number: 201112/75
X-Sequence-Number: 38833

This is a multi-part message in MIME format.
--------------000602030803050005010402
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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

--------------000602030803050005010402
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    On 12/15/2011 02:52 AM, P R wrote:
    <blockquote cite="mid:BAY157-W221EC85F1F073C983A2623B4A20@phx.gbl"
      type="cite">
      <style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
      <div dir="ltr">
        Is there any way to resume an incomplete Pg-restore from a
        custom Pgdump file?<br>
      </div>
    </blockquote>
    <br>
    Not reliably.<br>
    <br>
    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.<br>
    <br>
    --<br>
    Craig Ringer<br>
  </body>
</html>

--------------000602030803050005010402--