Re: 'missing' data on replicate

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.