[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] Resume Incomplete Pg-restore
From:       Craig Ringer <ringerc () ringerc ! id ! au>
Date:       2011-12-15 0:52:16
Message-ID: 4EE944C0.4080404 () ringerc ! id ! au
[Download RAW message or body]

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

[Attachment #3 (text/html)]

<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>


[prev in list] [next in list] [prev in thread] [next in thread]

Configure | About | News | Add a list | Sponsored by KoreLogic