Question

9

apt-get upgrade stuck on postgresql dependency

rated 0 times [ 9] [ 0] / answers: 1 / hits: 7155 / 2 Years ago, thu, september 15, 2022, 1:19:56

I ran sudo apt-get upgrade on my 12.04 server, and I have become stuck with a PostgreSQL dependency.

The console output (of sudo apt-get -f install) is below:

dpkg: dependency problems prevent configuration of postgresql-9.1:

  postgresql-client-9.1 (9.1.7-0ubuntu12.04) breaks postgresql-9.1 (<< 9.1.7-0ubuntu12.04) and is installed.

  Version of postgresql-9.1 to be configured is 9.1.6-1~precise2.

dpkg: error processing postgresql-9.1 (--configure):

  dependency problems - leaving unconfigured

No apport report written because the error message indicates its a followup error from a previous failure.

 Errors were encountered while processing:

 postgresql-9.1

E: Sub-process /usr/bin/dpkg returned an error code (1)

How do I resolve this issue?

nb. I have a production database running on this server, so purge/reinstall of postgres is a last resort.

Edit:

As requested, the output of apt-get update: http://paste.ubuntu.com/1469631/

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

alliulet

Add To Favorites

Follow

Total Points: 46

Total Questions: 109

Total Answers: 97

Location: Svalbard and Jan Mayen

Member since Sat, Oct 10, 2020

4 Years ago

answered 2 Years ago fulpu · Accepted Answer

I experienced this same problem with this postgresql update.

The newest version of postgres is 9.1.7, for some reason 9.1.6 is not in the repository, so here is how I downgraded to 9.1.5:

sudo apt-get -V install postgresql-client-9.1=9.1.5-0ubuntu12.04 

sudo apt-get -V install postgresql-9.1=9.1.5-0ubuntu12.04

Note that I downgraded to client first. It appears there is a bug in the latest update, which causes a dependency error between the client and the server.

edit:
If you want to prevent postgresql from upgrading in the future see this page:
https://help.ubuntu.com/community/PinningHowto. Be sure to apply this method to both the client and the server.