Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lodPu-00041i-6y for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 03 Jun 2021 02:49:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lodPs-0008Jo-JC for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 03 Jun 2021 02:49:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lodPs-0008Je-DF for pgsql-pkg-debian@lists.postgresql.org; Thu, 03 Jun 2021 02:49:04 +0000 Received: from mail-il1-x129.google.com ([2607:f8b0:4864:20::129]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lodPo-0006WU-1D for pgsql-pkg-debian@lists.postgresql.org; Thu, 03 Jun 2021 02:49:03 +0000 Received: by mail-il1-x129.google.com with SMTP id d1so1115865ils.5 for ; Wed, 02 Jun 2021 19:48:59 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pavely.net; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=1MP+XYX7Q2MkLNiQPJm5GiQkf1AMogOxszwXOBcEUmA=; b=gkZ5gds/9X2c9OmVlwx8GJBN1qXBF4k88nH98gPBXtuzjZWMXlvT5FsUcZDux01K2x pNnzt4BeH118s5WCj8oJD5pB7Biga5NX69S/bvGLd2EKw06Pb1VUHsGzD4XTnR9BzH/9 x2AOOLW8rupHwiTJdNmP4rzPnRPH7XZI3nlNg= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=1MP+XYX7Q2MkLNiQPJm5GiQkf1AMogOxszwXOBcEUmA=; b=HxjNgtd8t5YmEcbGkHRj6+hGi1BLATA04mN5GrM7cLqYhMsb3wgsJE7SDhkksqBFWF GtqMPRf0eeznWpN3SFyBTWmRIYvwzwknnP5mz9e0EflSnBVfTs7RW6Llswe5wq3fBOg8 r2mL/16inRFbboCPf0GflrxG1Z1zhhjLJYH6PYhwMXGE2s+csEaFbEh03ECjs5pVWWlZ MEo3tHu1s52WyxMPB5wfyLVZINa04bSBEgjIn0LqPnwT+4Bh1QpRg2ru0hsegM6SCz/F yiFq+T0/FuduI788nKgetoqRicfZHpP2wxE6hQnLE8DArKUmTUVhNQLKaIO++kEec+B3 XeDQ== X-Gm-Message-State: AOAM530uUTvmSY2a79l7WZK1CEBQrxUCem43iSJAgSkqkqr7+C6p1NQz WCA0M/68FQpclj+2s3oSsnyASU1innNxs8MOQBoZeQ== X-Google-Smtp-Source: ABdhPJwkSyBGLW0ccBtdR2cyFjSI+aNH5NggRWMHi67ulzHzKTkgIESXA87NyE/Xt938psEcT0kz1lehYo/0K9iUZso= X-Received: by 2002:a05:6e02:1745:: with SMTP id y5mr2700861ill.169.1622688538147; Wed, 02 Jun 2021 19:48:58 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Aaron Pavely Date: Wed, 2 Jun 2021 21:48:47 -0500 Message-ID: Subject: Re: Postgres 13 package on Debian 10 has unmet dependencies To: Fernando Hevia Cc: pgsql-pkg-debian@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000e5dbcc05c3d39d83" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e5dbcc05c3d39d83 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Jun 2, 2021 at 9:11 PM Fernando Hevia 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=C3=A9, 2 de jun. de 2021 a la(s) 21:54, Aaron Pavely (aaron@pavely.= net) > escribi=C3=B3: > >> On Wed, Jun 2, 2021 at 6:47 PM Fernando Hevia wrote: >> >>> Hi list. >>> >>> As the subject states, I am facing an unmet dependency issue with libpq= 5 >>> while installing Postgres 13 on Debian 10.9. (BTW, same thing happens w= ith >>> 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 (>=3D 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 priorit= ies >> 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 --000000000000e5dbcc05c3d39d83 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Jun 2, 2021 at 9:11 PM Fernando Hevia= <fhevia@gmail.com> wrote:
<= b># apt-cache policy libpq5
libpq5:
=C2=A0 Installed: (none)
= =C2=A0 Candidate: 11.12-0+deb10u1
=C2=A0 Version table:
=C2=A0 =C2=A0= =C2=A013.3-1.pgdg100+1 500
=C2=A0 =C2=A0 =C2=A0 =C2=A0 500 http://apt.postgr= esql.org/pub/repos/apt buster-pgdg/main amd64 Packages
=C2=A0 =C2=A0= =C2=A011.12-0+deb10u1 990
=C2=A0 =C2=A0 =C2=A0 =C2=A0 990 http://security= .debian.org/debian-security buster/updates/main amd64 Packages
=C2= =A0 =C2=A0 =C2=A011.11-0+deb10u1 990
=C2=A0 =C2=A0 =C2=A0 =C2=A0 990 http://ftp.us.de= bian.org/debian buster/main amd64 Packages


<= /div>

El mi=C3=A9, 2 de jun. de 2021 a la(s) 21:54, Aaron Pavely (aaron@pavely.net) escribi= =C3=B3:
O= n Wed, Jun 2, 2021 at 6:47 PM Fernando Hevia <fhevia@gmail.com> wrote:
Hi list.
<= br>
As the subject states, I am facing an unmet dependency issue = with libpq5 while installing Postgres 13 on Debian 10.9. (BTW, same thing h= appens with PG 12).

I am using postgresql reposito= ry:

# cat /etc/apt/sources.list.d/pgdg.list
deb http://apt.postgresql.org/pub/repos/apt buster-pgdg main=C2=A0
<= /div>

# apt install=C2=A0postgresql-13=C2=A0postgresq= l-client-13
Reading package lists... Done
Building depende= ncy tree =C2=A0 =C2=A0 =C2=A0
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 th= at some required packages have not yet been created
or been moved out of= Incoming.
The following information may help to resolve the situation:<= br>
The following packages have unmet dependencies:
=C2=A0postgresql-= client-13 : Depends: libpq5 (>=3D 13.3) but 11.12-0+deb10u1 is to be ins= talled
E: Unable to correct problems, you have held broken packages.
=

When looking for libpq5 available versions only v= 11.12 is listed.

# apt search libpq5
Sor= ting... Done
Full Text Search... Done
libpq-dev/stable 11.12-0+deb10u= 1 amd64
=C2=A0 header files for libpq5 (PostgreSQL library)

libpq= 5/stable 11.12-0+deb10u1 amd64
=C2=A0 PostgreSQL C client library
libpq5-dbgsym/buster-pgdg 13.3-1.pgdg100+1 amd64
=C2=A0 debug symbols f= or libpq5

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

T= hanks,
Fernando.=C2=A0

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

Aaron=

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

Aaron
--000000000000e5dbcc05c3d39d83--