Problems when upgrading postgresql-contrib-9.6

From: Marco DE BOOIJ <marco(dot)maillist(at)debooy(dot)eu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Problems when upgrading postgresql-contrib-9.6
Date: 2017-08-18 12:11:12
Message-ID: d42449ba-08eb-1f20-d48c-d28e03d825f3@debooy.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Last week I tried to upgradpostgresql-contrib-9.6e my Debian server.
There was a patch for postgresql-contrib-9.6. The upgrade failed because
postgresql-9.6 was not configured. I searched the web and tried several
solutions (apt-get remove, apt-get install postgres, use the --force
option) but nothing helped. I do not want to do a purge because it is a
production server. This there a way to update this version 9.6 or should
I wait for version 9.7 or 10.0?

Below is some information.

root:~# dpkg-query -l | grep postgres
ii pgdg-keyring 2017.1
iU postgresql 9.6+184.pgdg80+1
iF postgresql-9.6 9.6.4-1.pgdg80+1
ii postgresql-client-9.6 9.6.4-1.pgdg80+1
ii postgresql-client-common 184.pgdg80+1
ii postgresql-common 184.pgdg80+1
iU postgresql-contrib 9.6+184.pgdg80+1
iU postgresql-contrib-9.6 9.6.4-1.pgdg80+1
root:~# apt-get install postgresql postgresql-contrib
Reading package lists... Done
Building dependency tree
Reading state information... Done
postgresql is already the newest version.
postgresql-contrib is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
4 not fully installed or removed.
After this operation, 0 B of additional disk space will be used.
Do you want to continue? [Y/n]
Setting up postgresql-9.6 (9.6.4-1.pgdg80+1) ...
dpkg: error processing package postgresql-9.6 (--configure):
subprocess installed post-installation script returned error exit
status 102
dpkg: dependency problems prevent configuration of postgresql:
postgresql depends on postgresql-9.6; however:
Package postgresql-9.6 is not configured yet.

dpkg: error processing package postgresql (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of postgresql-contrib-9.6:
postgresql-contrib-9.6 depends on postgresql-9.6 (= 9.6.4-1.pgdg80+1);
however:
Package postgresql-9.6 is not configured yet.

dpkg: error processing package postgresql-contrib-9.6 (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of postgresql-contrib:
postgresql-contrib depends on postgresql-contrib-9.6; however:
Package postgresql-contrib-9.6 is not configured yet.

dpkg: error processing package postgresql-contrib (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
postgresql-9.6
postgresql
postgresql-contrib-9.6
postgresql-contrib
E: Sub-process /usr/bin/dpkg returned an error code (1)
root:~# cat /etc/apt/sources.list.d/pgdg.list
deb http://apt.postgresql.org/pub/repos/apt/ jessie-pgdg main
root:~# systemctl | grep postgres
srv-postgres.mount loaded active mounted /srv/postgres
postgresql.service loaded active exited PostgreSQL RDBMS
postgresql(at)9(dot)6-main(dot)service loaded active running PostgreSQL Cluster
9.6-main
system-postgresql.slice loaded active active system-postgresql.slice
root:~#

Browse pgsql-admin by date

  From Date Subject
Next Message anand086 2017-08-18 16:50:47 Analyze Table
Previous Message Achilleas Mantzios 2017-08-18 10:04:58 Re: LDAP authentication fails with more than one entry returned