From: | Jonathan Eastgate <jonathan(dot)eastgate(at)simpro(dot)co> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Sequences / Replication |
Date: | 2016-10-20 08:10:53 |
Message-ID: | CAF0Mkq-uQTNz6ZgWT8FxQY3VKHk7cS2HfuthwEuGd6XQ5Av3TQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
And further to my last post - another post in the forums related to this:
https://devon.so/2015/02/06/as-tale-of-sequences-and-postgresql-replication-9/
Thanks.
*Jonathan J. Eastgate*
Chief Technology Officer | simPRO Software Group
Ph: 1300 139 467 +61 7 3147 8777
<http://simprogroup.com/au/email-redirect>
Keep up to date with simPRO at: http://simprogroup.com/blog
The contents of this email are subject to our email disclaimer
<http://simprogroup.com/au/legal/email-confidentiality-notice>.
On Thu, Oct 20, 2016 at 6:03 PM, Jonathan Eastgate <
jonathan(dot)eastgate(at)simpro(dot)co> wrote:
> Hi everyone.
>
> We're seeing some odd behaviour from a PostgreSQL group - one running as
> primary and the other as a hot slave using streaming replication.
>
> When a failover event occurs and we switch to the hot slave as primary
> sequences in tables jump by 33 - so where the last number allocated in the
> sequence was 100 prior to failover once adding the next entry the sequence
> will produce the number 133.
>
> https://stackoverflow.com/questions/38450394/postgresql-
> sequence-jump-30-or-33-number-with-cache-equals-1
>
> I've found the following post in the forums - but any advice on how to
> resolve or counter this would be appreciated.
>
> Thanks in advance.
>
>
> *Jonathan J. Eastgate*
> Chief Technology Officer | simPRO Software Group
> Ph: 1300 139 467 +61 7 3147 8777
>
> <http://simprogroup.com/au/email-redirect>
>
> Keep up to date with simPRO at: http://simprogroup.com/blog
> The contents of this email are subject to our email disclaimer
> <http://simprogroup.com/au/legal/email-confidentiality-notice>.
>
>
--
--
From | Date | Subject | |
---|---|---|---|
Next Message | Jaisingkar, Piyush | 2016-10-20 09:40:47 | Unnest an array in postgresql |
Previous Message | Jonathan Eastgate | 2016-10-20 08:03:03 | Sequences / Replication |