| 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: | Whole Thread | Raw Message | 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 |