Re: PostgreSQL 9.3.3 and Hot standby

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: fburgess(at)radiantblue(dot)com
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.3.3 and Hot standby
Date: 2014-02-28 02:21:31
Message-ID: CAB7nPqS2YgXnuiT29igG8q_QkeTY5QAeinw811uPi8NabcRBdw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Fri, Feb 28, 2014 at 1:28 AM, <fburgess(at)radiantblue(dot)com> wrote:
> We currently have PostgreSQL 9.3.2 running in production, but we are still
> in the process of standing up a Hot standby server. The release notes for
> 9.3.3 indicates "Replication and Data Integrity Fixes". Do we need to apply
> the 9.3.3 patch before we configure the Hot Standby server? Or can we get
> by. I noticed that in the release notes it says "We have also fixed three
> bugs which could cause new standbys to fail to start up" and "Importantly,
> standby servers must be updated to 9.3.3 or later before the replication
> master is updated, or replication will be broken"
If you do not have yet a standby set up, going ahead with first doing
the update to 9.3.3, restarting the master and then setting up a
standby would be a natural way of doing IMO. If you have already a
standby set up, first update the standby, then the master.
Regards,
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2014-02-28 02:29:04 Re:
Previous Message jenifersouza8 2014-02-28 00:09:25 BUG #9376: erro na instalação