Re: 'missing' data on replicate

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(dot)klaver(at)aklaver(dot)com