[ADMIN] Problems when upgrading postgresql-contrib-9.6 - Mailing list pgsql-admin
From | Marco DE BOOIJ |
---|---|
Subject | [ADMIN] Problems when upgrading postgresql-contrib-9.6 |
Date | |
Msg-id | d42449ba-08eb-1f20-d48c-d28e03d825f3@debooy.eu Whole thread Raw |
List | 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@9.6-main.service loaded active running PostgreSQL Cluster 9.6-main system-postgresql.slice loaded active active system-postgresql.slice root:~#
pgsql-admin by date: