Gap in sequence after fail-over - Mailing list pgsql-admin

From Simon Luijk
Subject Gap in sequence after fail-over
Date
Msg-id BANLkTin3ZF=AujmZqXtzbs3j8Xcy-pjwug@mail.gmail.com
Whole thread Raw
Responses Re: Gap in sequence after fail-over  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-admin
I have two test systems with Postgresql in Hot-standby configuration. The intention
is to fail-over to the slave every so often. When ever we switch servers (fail-over)
and start inserting data, the primary ids have a gap of ~30. From the following
thread form 2001 it seems this maybe expected?

http://archives.postgresql.org/pgsql-bugs/2001-12/msg00082.php

With a Hot-standby set-up like this, that regularly switches, can I not rely on
the sequence always incrementing by 1?

Thank you
Simon

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Postgres 9 slave lag
Next
From: Simon Riggs
Date:
Subject: Re: Gap in sequence after fail-over