From: | bricklen <bricklen(at)gmail(dot)com> |
---|---|
To: | Vicky Soni - Quipment India <vicky(dot)soni(at)quipment(dot)nl> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: PITR Setup Using Hot StandBy |
Date: | 2016-05-25 16:01:45 |
Message-ID: | CAGrpgQ_oatAhfJ2Eoi=wtVg-aCGz98-gh8BPqjR6DkN_DZuk8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
On Wed, May 25, 2016 at 12:51 AM, Vicky Soni - Quipment India <
vicky(dot)soni(at)quipment(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Glen-Young | 2016-05-26 19:37:24 | Systemtap + Postgresql production readiness |
Previous Message | Vicky Soni - Quipment India | 2016-05-25 11:04:06 | Re: very slow postgresql startup |