[Pkg-postgresql-public] Bug#681344: postgresql-common: pg_upgradecluster should use pg_ctlcluster stop --force to shut down the cluster

[Martin von Wittich]

Package: postgresql-common
Version: 113
Severity: normal

Currently, pg_upgradecluster uses the following code to shut down the
cluster:

# stopping old cluster, so that we notice early when there are still
# connections
print "Stopping old cluster...\n";
my @argv = ('pg_ctlcluster', $version, $cluster, 'stop', '--', '-t', '5');
error "Could not stop old cluster" if system @argv;

This will cause pg_ctlcluster to shut down the cluster with the "smart"
mode, which will fail after 5 seconds when there are still open
connections to postgres:

Stopping old cluster...
pg_ctl: Server fährt nicht herunter
Error: Could not stop old cluster

pg_upgradecluster should either use --force by default or a parameter
should be added so that users can specify that they want a forced
shutdown.


-- System Information:
Debian Release: 6.0.5
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: i386 (x86_64)

Kernel: Linux 2.6.32-5-amd64 (SMP w/8 CPU cores)
Locale: LANG=de_DE.UTF-8, LC_CTYPE=en_US.utf8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages postgresql-common depends on:
ii  adduser                3.112+nmu2        add and remove users and groups
ii  debconf [debconf-2.0]  1.5.36.1          Debian configuration management sy
ii  lsb-base               3.2-23.2squeeze1  Linux Standard Base 3.2 init scrip
ii  postgresql-client-comm 113               manager for multiple PostgreSQL cl
ii  procps                 1:3.2.8-9squeeze1 /proc file system utilities
ii  ssl-cert               1.0.28            simple debconf wrapper for OpenSSL

postgresql-common recommends no packages.

postgresql-common suggests no packages.

-- debconf information:
* postgresql-common/obsolete-major:
  postgresql-common/untransitioned: