On 02/27/2015 10:04 AM, David G Johnston wrote:
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
To add to the above, even if they are similar enough I seem to remember
index corruption if the character sets is not the same. Might want to
check system character sets on your machines.
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.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
