Message-ID: <518CA0F9.7020600@okservers.eu>
Date: Fri, 10 May 2013 10:25:45 +0300
From: Viktor <viktor@okservers.eu>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:17.0) Gecko/20130328 Thunderbird/17.0.5
MIME-Version: 1.0
To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Point in time recovery + replication
References: 
 <CALyjCLt-DoLgxH=SptT5NZt63HBiJL44BD5tH3NvBOC=J1Uoqw@mail.gmail.com>
In-Reply-To: 
 <CALyjCLt-DoLgxH=SptT5NZt63HBiJL44BD5tH3NvBOC=J1Uoqw@mail.gmail.com>
Content-Type: multipart/alternative;
	boundary="------------050000020306030902020304"
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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

Hei,

I think, that it can be done just via RSYNC with stopped both of databases:

http://www.debian-administration.org/article/How_to_setup_Postgresql_9.1_Streaming_Replication_Debian_Squeeze

Just like in the "*Getting it working*" part.


On 5/9/2013 6:45 PM, German Becker wrote:
> Hello Everyone,
>
> I have a primary  / hot standby scenario with streaming replication. 
> Postgres version is 9.1.8.
>
> A full backup is made nightly on the primary and copied to the 
> secondary, just for backup purposes, the replication is never stopped 
> /restarted.
>
> Supose that for a reason I need to restore the primary to a point in 
> time, let's say just after the last backup. I've done this by:
>
> 1) stoping de databese
> 2)restoring the backup
> 3) creatng a recovery.conf where I specified a recovery_target accordingly
> 4) start the database
>
> This works fine on the primary. The quesion is how do I restart the 
> replication on the secondary, on the new timeline?
>
> I tried to restore the same backup on the secondary and starting 
> the continuous recovery, but it starts on the previous timeline.
> I also tried to set the recovery_target_timeline in the secondary to 
> the new timeline, but I get an error. Do I need to get a new copy of 
> the primary to continue the replication?


--------------050000020306030902020304
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 text="#000000" bgcolor="#FFFFFF">
    <div class="moz-cite-prefix">Hei,<br>
      <br>
      I think, that it can be done just via RSYNC with stopped both of
      databases:<br>
      <br>
<a class="moz-txt-link-freetext" href="http://www.debian-administration.org/article/How_to_setup_Postgresql_9.1_Streaming_Replication_Debian_Squeeze">http://www.debian-administration.org/article/How_to_setup_Postgresql_9.1_Streaming_Replication_Debian_Squeeze</a><br>
      <br>
      Just like in the "<b>Getting it working</b>" part.<br>
      <br>
      <br>
      On 5/9/2013 6:45 PM, German Becker wrote:<br>
    </div>
    <blockquote
cite="mid:CALyjCLt-DoLgxH=SptT5NZt63HBiJL44BD5tH3NvBOC=J1Uoqw@mail.gmail.com"
      type="cite">
      <div dir="ltr">
        <div style="">Hello Everyone,</div>
        <div style=""><br>
        </div>
        I have a primary &nbsp;/ hot standby scenario with streaming
        replication. Postgres version is 9.1.8.&nbsp;
        <div><br>
        </div>
        <div style="">A full backup is made nightly on the primary and
          copied to the secondary, just for backup purposes, the
          replication is never stopped /restarted.</div>
        <div style=""><br>
        </div>
        <div style="">Supose that for a reason I need to restore the
          primary to a point in time, let's say just after the last
          backup. I've done this by:</div>
        <div style=""><br>
        </div>
        <div style="">1) stoping de databese</div>
        <div style="">2)restoring the backup</div>
        <div style="">3) creatng a recovery.conf where I specified a
          recovery_target accordingly</div>
        <div style="">4) start the database</div>
        <div style=""><br>
        </div>
        <div style="">This works fine on the primary. The quesion is how
          do I restart the replication on the secondary, on the new
          timeline?</div>
        <div style=""><br>
        </div>
        <div style="">I tried to restore the same backup on the
          secondary and starting the&nbsp;continuous&nbsp;recovery, but it starts
          on the previous timeline.</div>
        <div style="">I also tried to set the recovery_target_timeline
          in the secondary to the new timeline, but I get an error. Do I
          need to get a new copy of the primary to continue the
          replication?</div>
      </div>
    </blockquote>
    <br>
  </body>
</html>

--------------050000020306030902020304--