Re: 'missing' data on replicate

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 'missing' data on replicate
Date: 2015-02-27 18:04:34
Message-ID: 1425060274533-5839764.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2015-02-27 18:11:49 Re: 'missing' data on replicate
Previous Message Adam Hooper 2015-02-27 18:02:31 Re: Hex characters in COPY input