Re: [ADMIN] Gap in sequence after fail-over

2011-04-12 Thread Simon Riggs
On Tue, Apr 12, 2011 at 9:28 AM, Simon Luijk wrote: > 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 t

[ADMIN] Gap in sequence after fail-over

2011-04-12 Thread Simon Luijk
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? ht