[ADMIN] Problems when upgrading postgresql-contrib-9.6

Поиск
Список
Период
Сортировка
От Marco DE BOOIJ
Тема [ADMIN] Problems when upgrading postgresql-contrib-9.6
Дата
Msg-id d42449ba-08eb-1f20-d48c-d28e03d825f3@debooy.eu
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: [ADMIN] LDAP authentication fails with more than one entryreturned
Следующее
От: anand086
Дата:
Сообщение: [ADMIN] Analyze Table