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: 200810050922.m959MGc0095116@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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
Details:

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.

Browse pgsql-bugs by date

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