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

2018-05-24 Thread Michael Paquier
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

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

2018-05-24 Thread talk to ben
Hi, - Doing Streaming Replication between different minor version of PG is possible but not recommended [2] - Doing Streaming Replication between different OSes is not recommended pre ICU (pg10), please check you glibc versions. [1] [1] https://www.postgresql.org/message-id/ba6132e

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

2018-05-22 Thread Jonatan Evald Buus
Thanks Ian, thank you for pointing out the obvious. It appears that Debian's *pg_dropcluster* command had unexpected consequences you live, you pull out your hair in frustration and you learn. I now have streaming replication working as we expected, can you confirm that my *(somewhat unusual s

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

2018-05-21 Thread Ian Barwick
On 05/21/2018 07:18 PM, Jonatan Evald Buus wrote: > Hi there, > > I'm trying to configure streaming replication between a Red Hat server > running PostGreSQL 9.2.2 and a Debian server running PostGreSQL 9.2.24 > with Hot Standby enabled. > > While the base backup works fine using /pg_basebackup/,

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

2018-05-21 Thread Jonatan Evald Buus
Hi there, I'm trying to configure streaming replication between a Red Hat server running PostGreSQL 9.2.2 and a Debian server running PostGreSQL 9.2.24 with Hot Standby enabled. While the base backup works fine using *pg_basebackup*, I get the following errors with hot standby enabled on the Debi