Re: [GENERAL] Sequences / Replication

2016-10-21 Thread Albe Laurenz
Jonathan Eastgate wrote: > 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 l

Re: [GENERAL] Sequences / Replication

2016-10-20 Thread Alvaro Aguayo Garcia-Rada
From: "Jonathan Eastgate" To: "PostgreSql-general" Sent: Thursday, 20 October, 2016 03:10:53 Subject: Re: [GENERAL] Sequences / Replication 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-postgres

Re: [GENERAL] Sequences / Replication

2016-10-20 Thread Jonathan Eastgate
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

[GENERAL] Sequences / Replication

2016-10-20 Thread Jonathan Eastgate
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