Re: [GENERAL] Sequences / Replication

2016-10-20 Thread Jonathan Eastgate
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.eastg...@s

[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

Re: [GENERAL] BDR Cluster vs DB Config

2016-07-20 Thread Jonathan Eastgate
rogroup.com/blog The contents of this email are subject to our email disclaimer <http://simprogroup.com/au/legal/email-confidentiality-notice>. On Wed, Jul 20, 2016 at 5:18 PM, Craig Ringer wrote: > On 20 July 2016 at 13:22, Jonathan Eastgate > wrote: > >> Hi everyone. >

[GENERAL] BDR Cluster vs DB Config

2016-07-19 Thread Jonathan Eastgate
Hi everyone. We've been testing BDR on and off for the last 2 years and are keen to start looking at implementing it in production as it seems 0.93 has resolved most of the issues we faced with it in the early days. However there is still one item that makes it a difficult proposition... DSN con