Point in time recovery + replication

From: German Becker <german(dot)becker(at)gmail(dot)com>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Point in time recovery + replication
Date: 2013-05-09 15:45:55
Message-ID: CALyjCLt-DoLgxH=SptT5NZt63HBiJL44BD5tH3NvBOC=J1Uoqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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?

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Miu, Monica 2013-05-10 00:01:43 Sr. Postgres DBA
Previous Message German Becker 2013-05-09 15:27:26 Re: archive falling behind