postgresql-client-common is not compatible with current postgresql-servers

[Marc F. Neininger]

Hi,
i'm using 16.04 xenial as host for applications. Our DB-server was updated from 9.4 to 9.6 recently and I'm using pg_dump from time to time to clone databases. But I'm no more able to do that :-(

Right now postgresql-client-common can connect to pg up to version 9.5 . I tried to install postgresql-client-9.6 manually but I failed because postgresql-client-9.6 depends on a newer version of libpg5. As a workaround I tried to manually install the latest version of libpg5 (9.6.7) but another depenency (libgss...?) failed.
Can you please have a look or even ask upstream about the possibility to provide postgresql-client for all current server versions (9.6,and 10.2??)

Nevertheless thank you all for providing the software. It works like a charm

Marc

[Marc F. Neininger (champagnierle)]

Hello,

can anyone please tell me how to use pg_dump in Xenial with a postgresql Server 9.6?
I would really appreciate any solution as I'm no more capable to dump any databases from 9.6 Servers :-/

TIA

Marc

[Marc F. Neininger (champagnierle)]

to whom it may concern:
I tried to install postgresql-client-9.6 for amd64.

postgresql-client-9.6 cannot be installed because it
   depends on libpq5 (installed: 9.5.11 required: 9.6.7)
   libpq5 cannot be updated because it
      depends on libgssapi-krb5-2 (installed: 1.13.2 required: >= 1.14)
   libgssapi-krb5-2 cannot be updated because it
       depends on libkrb5-3 (installed: 1.13.2 required: =1.15.1-2
    depends on libkrb5support0 (installed: 1.13.2 required: =1.15~beta1

All other dependencies of the examined packages were fulfilled in xenial.

So the postgresql-client cannot be updated because of missing kerberos-libs :-/

Is there a chance that the kerberos libs might be backported to xenial?

TIA
Marc

[Christian Ehrhardt  (paelzer)]

Hi,
the version in Xenial is afaik only postgresql 9.5 (for the server and the tools).
9.6 would be available in later releases like Ubuntu 17.10 and Ubuntu 18.04 is already on postgresql-10.

I would not even see how you start to install postgresql-client-9.6 in xenial without adding non supported out-of-archive repositories.

apt-cache policy postgresql-client-9.5 postgresql-client-9.6
postgresql-client-9.5:
  Installed: 9.5.12-0ubuntu0.16.04
  Candidate: 9.5.13-0ubuntu0.16.04
  Version table:
     9.5.13-0ubuntu0.16.04 500
        500 http://archive.ubuntu.com/ubuntu xenial-updates/main amd64 Packages
 *** 9.5.12-0ubuntu0.16.04 500
        500 http://security.ubuntu.com/ubuntu xenial-security/main amd64 Packages
        100 /var/lib/dpkg/status
     9.5.2-1 500
        500 http://archive.ubuntu.com/ubuntu xenial/main amd64 Packages
N: Unable to locate package postgresql-client-9.6
N: Couldn't find any package by glob 'postgresql-client-9.6'
N: Couldn't find any package by regex 'postgresql-client-9.6'

[Christian Ehrhardt  (paelzer)]

TL;DR to get a newer version of postrgesql-client you need to update your Ubuntu Releases

[Marc F. Neininger (champagnierle)]

Hi Christian,
as the server is a productive one I cannot just test to update to a dev-tagged release...
So I'm really awaiting 18.04.01 to upgrade 16.04 to 18.04.

Best regards

Marc

> Christian Ehrhardt <email address hidden> hat am 26. Juni 2018 um 14:11 geschrieben:
>
>
> Hi,
> the version in Xenial is afaik only postgresql 9.5 (for the server and the tools).
> 9.6 would be available in later releases like Ubuntu 17.10 and Ubuntu 18.04 is already on postgresql-10.
>
> I would not even see how you start to install postgresql-client-9.6 in
> xenial without adding non supported out-of-archive repositories.
>
> apt-cache policy postgresql-client-9.5 postgresql-client-9.6
> postgresql-client-9.5:
> Installed: 9.5.12-0ubuntu0.16.04
> Candidate: 9.5.13-0ubuntu0.16.04
> Version table:
> 9.5.13-0ubuntu0.16.04 500
> 500 http://archive.ubuntu.com/ubuntu xenial-updates/main amd64 Packages
> *** 9.5.12-0ubuntu0.16.04 500
> 500 http://security.ubuntu.com/ubuntu xenial-security/main amd64 Packages
> 100 /var/lib/dpkg/status
> 9.5.2-1 500
> 500 http://archive.ubuntu.com/ubuntu xenial/main amd64 Packages
> N: Unable to locate package postgresql-client-9.6
> N: Couldn't find any package by glob 'postgresql-client-9.6'
> N: Couldn't find any package by regex 'postgresql-client-9.6'
>
>
> ** Changed in: postgresql-common (Ubuntu)
> Status: New => Incomplete
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/1749585
>
> Title:
> postgresql-client-common is not compatible with current postgresql-
> servers
>
> Status in postgresql-common package in Ubuntu:
> Incomplete
>
> Bug description:
> Hi,
> i'm using 16.04 xenial as host for applications. Our DB-server was updated from 9.4 to 9.6 recently and I'm using pg_dump from time to time to clone databases. But I'm no more able to do that :-(
>
> Right now postgresql-client-common can connect to pg up to version 9.5 . I tried to install postgresql-client-9.6 manually but I failed because postgresql-client-9.6 depends on a newer version of libpg5. As a workaround I tried to manually install the latest version of libpg5 (9.6.7) but another depenency (libgss...?) failed.
> Can you please have a look or even ask upstream about the possibility to provide postgresql-client for all current server versions (9.6,and 10.2??)
>
> Nevertheless thank you all for providing the software. It works like a
> charm
>
> Marc
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/ubuntu/+source/postgresql-common/+bug/1749585/+subscriptions

==

Marc Neininger

Staufenstrasse 19

78224 Singen

07731 - 3190508

[Launchpad Janitor (janitor)]

[Expired for postgresql-common (Ubuntu) because there has been no activity for 60 days.]