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
