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@9.6-main.service loaded active running PostgreSQL Cluster
9.6-main
system-postgresql.slice loaded active active system-postgresql.slice
root:~#
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
