Re: Streaming Replication between PostGreSQL 9.2.2 on Red Hat and PostGreSQL 9.2.24 on Debian

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: talk to ben <blo(dot)talkto(at)gmail(dot)com>
Cc: Jonatan Evald Buus <jonatan(dot)buus(at)cellpointmobile(dot)com>, Ian Barwick <ian(dot)barwick(at)2ndquadrant(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Streaming Replication between PostGreSQL 9.2.2 on Red Hat and PostGreSQL 9.2.24 on Debian
Date: 2018-05-25 01:15:17
Message-ID: 20180525011517.GA3078@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, May 24, 2018 at 10:21:33AM +0200, talk to ben wrote:
> - Doing Streaming Replication between different minor version of PG is
> possible but not recommended [2]

Standbys need to be updated first, hence be careful that the primary is
not updated before the standbys or WAL generated on the primary may not
be able to replay on its standbys. Note however that you won't get
support for such configurations on the community lists, so just make
sure that all nodes in a cluster are on the same version and that it is
the latest one.
--
Michael

In response to

Browse pgsql-general by date

  From Date Subject
Next Message tango ward 2018-05-25 09:04:25 case statement within insert
Previous Message tango ward 2018-05-25 00:15:45 Re: Insert data if it is not existing