Thank you for that, makes sense. Another fine example of RTFM! alan > On Feb 27, 2015, at 10:04 AM, David G Johnston <david.g.johnston@xxxxxxxxx> 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 > > 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. > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general