Skip site navigation (1) Skip section navigation (2)

BUG #4449: allows "pg_ctl restart" to terminate idle processes

From: "Kevin M(dot) Kilbride" <kevinmkilbride(at)yahoo(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4449: allows "pg_ctl restart" to terminate idle processes
Date: 2008-10-05 09:22:16
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      4449
Logged by:          Kevin M. Kilbride
Email address:      kevinmkilbride(at)yahoo(dot)com
PostgreSQL version: 8.3
Operating system:   Gentoo GNU/Linux 2008.0
Description:        allows "pg_ctl restart" to terminate idle processes

Because a very large number of clients now habitually establish permanent
connections to PGSQL in order to alleviate startup overhead, the "smart"
restart mode of pg_ctl has become nearly useless because it will not
terminate idle processes.

It would be nice if pg_ctl were updated so that the "smart" restart mode
simply terminated idle processes (a la "fast mode"), but waited for active
processes to finish transactions before terminating them. This would restore
"low-impact restart" functionality to those systems with clients that
establish permanent connections...which is virtually everybody, these days.

pgsql-bugs by date

Next:From: CarlosDate: 2008-10-05 14:42:31
Subject: BUG #4450: Postgres do not ask for passord
Previous:From: Don HarterDate: 2008-10-03 22:33:49
Subject: Re: BUG #4448: postgres won't start with latest stable kernel

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group