[Pkg-postgresql-public] Bug#871986: postgresql-9.6: PostgreSQL fails to start after upgrade

Jacob Sparre Andersen jacob at jacob-sparre.dk
Sun Aug 13 08:19:33 UTC 2017


Package: postgresql-9.6
Version: 9.6.4-0+deb9u1
Severity: grave
Justification: renders package unusable

Dear Maintainer,

Last night I upgraded "postgresql-9.6" to the most recent version
(went from 9.6.3-3 to 9.6.4-0+deb9u1).

As a part of the upgrade PostgreSQL was shut down, and it has not come
up since then.

% ls -lFNart /var/log/postgresql
totalt 16
-rw-r-----  1 postgres adm       700 jul  2 06:25 postgresql-9.6-main.log.2.gz
-rw-r-----  1 postgres adm       341 aug 13 06:25 postgresql-9.6-main.log.1
drwxrwxr-t  2 root     postgres 4096 aug 13 06:25 ./
-rw-r-----  1 postgres adm         0 aug 13 06:25 postgresql-9.6-main.log
drwxr-xr-x 10 root     root     4096 aug 13 06:25 ../
% tail /var/log/postgresql/postgresql-9.6-main.log.1
2017-08-12 19:33:04 CEST [2060-2] LOG:  received fast shutdown request
2017-08-12 19:33:04 CEST [2060-3] LOG:  aborting any active transactions
2017-08-12 19:33:04 CEST [2065-2] LOG:  autovacuum launcher shutting down
2017-08-12 19:33:04 CEST [2062-1] LOG:  shutting down
2017-08-12 19:33:04 CEST [2060-4] LOG:  database system is shut down
%

I've tried "sudo service postgresql restart" without any visible effect.

/Jacob

-- System Information:
Debian Release: 9.1
  APT prefers stable
  APT policy: (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 4.9.0-3-amd64 (SMP w/2 CPU cores)
Locale: LANG=da_DK.UTF-8, LC_CTYPE=da_DK.UTF-8 (charmap=UTF-8), LANGUAGE=da:da_DK:fo:fo_FO:nb:nb_NO:nn:nn_NO:no:no_NO:sv:sv_SE:sv_FI:en_GB:en_DK:en_AU:en:it:it_IT:is:is_IS:fr:fr_FR:de:de_DE:en_US (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages postgresql-9.6 depends on:
ii  libc6                  2.24-11+deb9u1
ii  libgssapi-krb5-2       1.15-1
ii  libldap-2.4-2          2.4.44+dfsg-5
ii  libpam0g               1.1.8-3.6
ii  libpq5                 9.6.4-0+deb9u1
ii  libssl1.1              1.1.0f-3
ii  libsystemd0            232-25+deb9u1
ii  libxml2                2.9.4+dfsg1-2.2
ii  locales                2.24-11+deb9u1
ii  postgresql-client-9.6  9.6.4-0+deb9u1
ii  postgresql-common      181
ii  ssl-cert               1.0.39
ii  tzdata                 2017b-1

Versions of packages postgresql-9.6 recommends:
ii  postgresql-contrib-9.6  9.6.4-0+deb9u1
ii  sysstat                 11.4.3-2

Versions of packages postgresql-9.6 suggests:
ii  locales-all  2.24-11+deb9u1

-- no debconf information



More information about the Pkg-postgresql-public mailing list