Re: [GENERAL] 'missing' data on replicate

2015-02-27 Thread Adrian Klaver
On 02/27/2015 10:14 AM, Alan Nilsson wrote: Thank you for that, makes sense. Another fine example of RTFM! To go with my previous post, I knew this sounded familiar: http://www.postgresql.org/message-id/cadyruxojwgkh4ghxw2heqetfapiwzayj9uwg34bhyifxlrm...@mail.gmail.com in particular this res

Re: [GENERAL] 'missing' data on replicate

2015-02-27 Thread Alan Nilsson
Thank you for that, makes sense. Another fine example of RTFM! alan > On Feb 27, 2015, at 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). A

Re: [GENERAL] 'missing' data on replicate

2015-02-27 Thread Adrian Klaver
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

Re: [GENERAL] 'missing' data on replicate

2015-02-27 Thread David G Johnston
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

[GENERAL] 'missing' data on replicate

2015-02-27 Thread Alan Nilsson
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 o