Re: Streaming replication: sequences on slave seemingly ahead of sequences on master

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Simon Riggs <simon(at)2ndQuadrant(dot)com>
Cc: Vincent de Phily <vincent(dot)dephily(at)mobile-devices(dot)fr>, pgsql-general(at)postgresql(dot)org, benjamin(dot)vialle(at)mobile-devices(dot)fr
Subject: Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Date: 2012-05-07 13:33:45
Message-ID: 24170.1336397625@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> On 7 May 2012 09:01, Vincent de Phily <vincent(dot)dephily(at)mobile-devices(dot)fr> wrote:
>> Would be nice to see it added to the documentation (unless I just didn't find
>> it ?), as it is quite surprising, and might lead to problems if people expect
>> to be able to read sequence values from the slave.

> If you think so, please submit a patch. That's how it works here.

Any documentation patch should be written by somebody who's actually
researched the behavior a bit; in particular I believe this can be
adjusted with the sequence CACHE setting.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Nolan 2012-05-07 13:52:56 Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Previous Message Adrian Klaver 2012-05-07 13:13:05 Re: COPY column order