Re: Postgres 13 package on Debian 10 has unmet dependencies

On Wed, Jun 2, 2021 at 9:11 PM Fernando Hevia <fhevia@gmail.com> wrote:

# apt-cache policy libpq5
libpq5:
  Installed: (none)
  Candidate: 11.12-0+deb10u1
  Version table:
     13.3-1.pgdg100+1 500
        500 http://apt.postgresql.org/pub/repos/apt buster-pgdg/main amd64 Packages
     11.12-0+deb10u1 990
        990 http://security.debian.org/debian-security buster/updates/main amd64 Packages
     11.11-0+deb10u1 990
        990 http://ftp.us.debian.org/debian buster/main amd64 Packages

El mié, 2 de jun. de 2021 a la(s) 21:54, Aaron Pavely (aaron@pavely.net) escribió:

On Wed, Jun 2, 2021 at 6:47 PM Fernando Hevia <fhevia@gmail.com> wrote:

Hi list.

As the subject states, I am facing an unmet dependency issue with libpq5 while installing Postgres 13 on Debian 10.9. (BTW, same thing happens with PG 12).

I am using postgresql repository:

# cat /etc/apt/sources.list.d/pgdg.list
deb http://apt.postgresql.org/pub/repos/apt buster-pgdg main 

# apt install postgresql-13 postgresql-client-13

Reading package lists... Done
Building dependency tree      
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
 postgresql-client-13 : Depends: libpq5 (>= 13.3) but 11.12-0+deb10u1 is to be installed
E: Unable to correct problems, you have held broken packages.

When looking for libpq5 available versions only v11.12 is listed.

# apt search libpq5
Sorting... Done
Full Text Search... Done
libpq-dev/stable 11.12-0+deb10u1 amd64
  header files for libpq5 (PostgreSQL library)

libpq5/stable 11.12-0+deb10u1 amd64
  PostgreSQL C client library

libpq5-dbgsym/buster-pgdg 13.3-1.pgdg100+1 amd64
  debug symbols for libpq5

I could get around this by manually installing the correct libpq5 version, but I still wanted to share this issue with the list. Could it be a packaging error?

Thanks,

Fernando. 

Looks like there's a cross-over between Debian's own repository and the PGDG repository. I suspect there's differing weights between the priorities for each. What's the result of `apt-cache policy libpq5`?

Aaron

Looks like your apt pinning policies for your Debian repositories are set higher (990) than default (500). Is there a preference file changing the default in `/etc/apt/preferences.d/`?

For reference: https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_only_specific_packages_from_this_repository
https://wiki.debian.org/AptConfiguration

Aaron