[Pkg-postgresql-public] Bug#746273: postgres: postgresql-9.1 fails to upgrade when another instance is already running

[kardan]

Package: postgresql-9.1
Version: 9.1.13-0wheezy1
Severity: normal

# apt-get upgrade -y
Reading package lists... Done
Building dependency tree       
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up postgresql-9.1 (9.1.13-0wheezy1) ...
Starting PostgreSQL 9.1 database server: mainError: Port conflict:
another instance is already running on /var/run/postgresql with port
5432 ... failed! failed! invoke-rc.d: initscript postgresql, action
"start" failed. dpkg: error processing postgresql-9.1 (--configure):
 subprocess installed post-installation script returned error exit
status 1 Errors were encountered while processing:
 postgresql-9.1

# service postgresql stop
Stopping PostgreSQL 9.1 database server: mainError: pid file is invalid, please manually kill the stale server process. ... failed!
 failed!
# ps ax|grep postgres
 4991 ?        S      0:02 /usr/lib/postgresql/9.1/bin/postgres -D /var/lib/postgresql/9.1/main -c config_file=/etc/postgresql/9.1/main/postgresql.conf
 4994 ?        Ss     0:20 postgres: writer process
 4995 ?        Ss     0:16 postgres: wal writer process
 4996 ?        Ss     0:04 postgres: autovacuum launcher process
 4997 ?        Ss     0:03 postgres: archiver process   last was 0000000100000000000000B6
 4998 ?        Ss     0:03 postgres: stats collector process
# kill 4991 4994 4995 4996 4997 4998
# service postgresql stop
Stopping PostgreSQL 9.1 database server: main.

# apt-get upgrade -y
Reading package lists... Done
Building dependency tree       
Reading state information... Done
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Setting up postgresql-9.1 (9.1.13-0wheezy1) ...
Starting PostgreSQL 9.1 database server: main.

-- System Information:
Debian Release: 7.5
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.2.0-4-amd64 (SMP w/1 CPU core)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
(ignored: LC_ALL set to en_US.UTF-8) Shell: /bin/sh linked to /bin/dash

Versions of packages postgresql-9.1 depends on:
ii  libc6                  2.13-38+deb7u1
ii  libcomerr2             1.42.5-1.1
ii  libgssapi-krb5-2       1.10.1+dfsg-5+deb7u1
ii  libkrb5-3              1.10.1+dfsg-5+deb7u1
ii  libldap-2.4-2          2.4.31-1+nmu2
ii  libpam0g               1.1.3-7.1
ii  libpq5                 9.1.13-0wheezy1
ii  libssl1.0.0            1.0.1e-2+deb7u7
ii  libxml2                2.8.0+dfsg1-7+nmu3
ii  locales                2.13-38+deb7u1
ii  postgresql-client-9.1  9.1.13-0wheezy1
ii  postgresql-common      134wheezy4
ii  ssl-cert               1.0.32
ii  tzdata                 2014a-0wheezy1

postgresql-9.1 recommends no packages.

Versions of packages postgresql-9.1 suggests:
pn  locales-all             <none>
pn  oidentd | ident-server  <none>

-- no debconf information

-- 
6E0A4D784FDDDD94: 90E7 8C98 C58F 8442 5297  D461 6E0A 4D78 4FDD DD94
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 966 bytes
Desc: not available
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20140428/e3cca836/attachment.sig>