Re: Streaming replication: sequences on slave seemingly ahead of sequences on master - Mailing list pgsql-general

From Tom Lane
Subject Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
Date
Msg-id 24170.1336397625@sss.pgh.pa.us
Whole thread Raw
In response to Re: Streaming replication: sequences on slave seemingly ahead of sequences on master  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Streaming replication: sequences on slave seemingly ahead of sequences on master
List pgsql-general
Simon Riggs <simon@2ndQuadrant.com> writes:
> On 7 May 2012 09:01, Vincent de Phily <vincent.dephily@mobile-devices.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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: COPY column order
Next
From: Michael Nolan
Date:
Subject: Re: Streaming replication: sequences on slave seemingly ahead of sequences on master