Re: [HACKERS] pg_ctl stop -m immediate on the primary server inflates sequences

2010-04-12 Thread Boszormenyi Zoltan
Martijn van Oosterhout írta: > On Sat, Apr 10, 2010 at 02:36:41PM +0200, Boszormenyi Zoltan wrote: > The above is quite reproducable, "pg_ctl stop -m immediate" "usually" inflated my serial sequence, but I had two occasions when not. The 69 -> 70 was one. The inflated increase is

Re: [HACKERS] pg_ctl stop -m immediate on the primary server inflates sequences

2010-04-10 Thread Martijn van Oosterhout
On Sat, Apr 10, 2010 at 02:36:41PM +0200, Boszormenyi Zoltan wrote: > >> The above is quite reproducable, "pg_ctl stop -m immediate" > >> "usually" inflated my serial sequence, but I had two occasions > >> when not. The 69 -> 70 was one. The inflated increase is always 33: > > > > AFAIKS sequences

Re: [HACKERS] pg_ctl stop -m immediate on the primary server inflates sequences

2010-04-10 Thread Boszormenyi Zoltan
Bernd Helmle írta: > > > --On 10. April 2010 09:26:41 +0200 Boszormenyi Zoltan > wrote: > >> The above is quite reproducable, "pg_ctl stop -m immediate" >> "usually" inflated my serial sequence, but I had two occasions >> when not. The 69 -> 70 was one. The inflated increase is always 33: > > AFAI

Re: [HACKERS] pg_ctl stop -m immediate on the primary server inflates sequences

2010-04-10 Thread Bernd Helmle
--On 10. April 2010 09:26:41 +0200 Boszormenyi Zoltan wrote: The above is quite reproducable, "pg_ctl stop -m immediate" "usually" inflated my serial sequence, but I had two occasions when not. The 69 -> 70 was one. The inflated increase is always 33: AFAIKS sequences are pre-logged with

Re: [HACKERS] pg_ctl stop -m immediate on the primary server inflates sequences

2010-04-10 Thread Boszormenyi Zoltan
Boszormenyi Zoltan írta: > Hi, > > I wanted to test HS/SR and have setup two instances, one primary > and one secondary, the secondary is obviously a copy of the primary > while pg_start_backup() was in effect. > > I started up the secondary server after "SELECT pg_stop_backup()" on > the primary.

[HACKERS] pg_ctl stop -m immediate on the primary server inflates sequences

2010-04-10 Thread Boszormenyi Zoltan
Hi, I wanted to test HS/SR and have setup two instances, one primary and one secondary, the secondary is obviously a copy of the primary while pg_start_backup() was in effect. I started up the secondary server after "SELECT pg_stop_backup()" on the primary. I stopped and started the primary with