From: Viktor <viktor@okservers.eu>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Point in time recovery + replication
Date: Fri, 10 May 2013 10:25:45 +0300
Message-ID: <518CA0F9.7020600@okservers.eu> (raw)
In-Reply-To: <CALyjCLt-DoLgxH=SptT5NZt63HBiJL44BD5tH3NvBOC=J1Uoqw@mail.gmail.com>
References: <CALyjCLt-DoLgxH=SptT5NZt63HBiJL44BD5tH3NvBOC=J1Uoqw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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_Debia...
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: viktor@okservers.eu
Subject: Re: Point in time recovery + replication
In-Reply-To: <518CA0F9.7020600@okservers.eu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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