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