Re: PITR Setup Using Hot StandBy - Mailing list pgsql-admin

From bricklen
Subject Re: PITR Setup Using Hot StandBy
Date
Msg-id CAGrpgQ_oatAhfJ2Eoi=wtVg-aCGz98-gh8BPqjR6DkN_DZuk8A@mail.gmail.com
Whole thread Raw
In response to Re: PITR Setup Using Hot StandBy  ("Vicky Soni - Quipment India" <vicky.soni@quipment.nl>)
List pgsql-admin

On Wed, May 25, 2016 at 12:51 AM, Vicky Soni - Quipment India <vicky.soni@quipment.nl> wrote:
> 1.       Took base backup from hot standby
> 2.       WAL Archive from Master
> 3.       Configure recovery.conf and start new instance in standby mode.
> It worked.
> I just wanted it to be verified by some senior community member that, Is it ok strategy for PITR or not? Considering I want to take base backup from Read Only Replica.

Assuming your master is shipping WALs to the to-be-created replica, taking a base backup from an existing replica is perfectly fine.

pgsql-admin by date:

Previous
From: "Vicky Soni - Quipment India"
Date:
Subject: Re: very slow postgresql startup
Next
From: Andrew Glen-Young
Date:
Subject: Systemtap + Postgresql production readiness