Re: 'missing' data on replicate - Mailing list pgsql-general

From David G Johnston
Subject Re: 'missing' data on replicate
Date
Msg-id 1425060274533-5839764.post@n5.nabble.com
Whole thread Raw
In response to 'missing' data on replicate  (Alan Nilsson <anilsson@apple.com>)
Responses Re: 'missing' data on replicate  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: 'missing' data on replicate  (Alan Nilsson <anilsson@apple.com>)
List pgsql-general
Alan Nilsson wrote
> I have 4 machines in a cluster: 1 master & 2 replicates (hot standby mode)
> on OSX, 1 replicate (hot standby mode) on Linux (centos6.5).  All
> replicates were created with pg_basebackup (+ X option).
>
> I have a table that returns no results when queried by the primary key on
> the replicate running on Linux.

I was under the impression that binary replication requires that the master
and replicas both have the same underlying operating system (or at least
quite similar).  I'm guessing the OSX and Centos6.5 are not similar enough.

https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial

David J.



--
View this message in context: http://postgresql.nabble.com/missing-data-on-replicate-tp5839762p5839764.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Adam Hooper
Date:
Subject: Re: Hex characters in COPY input
Next
From: Adrian Klaver
Date:
Subject: Re: 'missing' data on replicate