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 1loiTi-0008Cf-Lo for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 03 Jun 2021 08:13:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1loiTA-0006V0-Mr for pgsql-pkg-debian@arkaria.postgresql.org; Thu, 03 Jun 2021 08:12:48 +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 1loiTA-0006Us-E7 for pgsql-pkg-debian@lists.postgresql.org; Thu, 03 Jun 2021 08:12:48 +0000 Received: from mail-yb1-xb34.google.com ([2607:f8b0:4864:20::b34]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1loiT3-0001c9-8j for pgsql-pkg-debian@lists.postgresql.org; Thu, 03 Jun 2021 08:12:47 +0000 Received: by mail-yb1-xb34.google.com with SMTP id b9so7625016ybg.10 for ; Thu, 03 Jun 2021 01:12:40 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=/bO4ELZX0fnqnYPYB+UcGeFDvECkLA67tfvHE74NLgo=; b=onnbESFecw9TtXtoRr4VplEo4+R2SQWwDOb6r67AG/bxUcMZhl/EeJkCkL9skjKJ2f eSAifq33Zpggwyaqd30enDMiH+weNbbr41iknYRjESYQt8Nv3RZLY8M2UWVLI+S1XFOE zOdwVmNk/TMaWL6C3EvUQmfHETDMpjbkof2ff3Dyns6u76C1HHkNE2/DdWzn3uG+DDtr bIwgwefmThtgQoQnrWSp+P6BwXO/CtiysRyrfA+e4L308f5w/pZmzhDcw7e4qkrtsSSc rx+LlnstFSwCDub+0KZkHUt3/ZbQ4kD1PR6trNzKKKEmRfXxw13ih+3OgGw5YONfwcfm hK6w== 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=/bO4ELZX0fnqnYPYB+UcGeFDvECkLA67tfvHE74NLgo=; b=N8wYMidHGl5/Y+T6lszutqxUkOH8vNM8pUT515GD397eB/I/kXO/nijD5G+d4U0/Br WDsqf1fx/8sFFpWcGMEbysXi+UQ/3SDD4mrbFZXbqxIvWe51UDQw2LWBTnbSRJ+ai2Tb wJdnmrbKQuYSLT1opsKer9O0KyqaXGHj1e1ED9LwV4fbKqCtgwT8Jgt+OVzcIDGjIaWo BR5fXdVOgfqWZ2YwGeIf/xyzk6uAlIyoNoCigm/XkehDD6U9cWZ2O4dgrk3eNKIlMkPd R3xH372PjK2CvuXBhXyxn8j/jsjLYnSTt0a4E9EppvSIQhz8RUpCsOV2pn4ocpPFIXs4 3vcQ== X-Gm-Message-State: AOAM533Pmmqe6HAFpMTfMUTV/WP00XYaTBSgCsjxeoCIUMM+p6pCEvun 6dWQuYsTpk1jYgCe9caI6MM5f2IsTJ5objkA+hp9T274J0dOQQ== X-Google-Smtp-Source: ABdhPJxHrzzu1b7an7nOBERI2bR89B15iz1Y7hCORXRoedi+5sDWYWrLb9wzfWF7ft9AttZIoZBSOMl3d3eEuz4E3VA= X-Received: by 2002:a25:ca48:: with SMTP id a69mr45014735ybg.125.1622707959263; Thu, 03 Jun 2021 01:12:39 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Fernando Hevia Date: Thu, 3 Jun 2021 05:12:26 -0300 Message-ID: Subject: Re: Postgres 13 package on Debian 10 has unmet dependencies To: Aaron Pavely Cc: pgsql-pkg-debian@lists.postgresql.org Content-Type: multipart/alternative; boundary="0000000000007c75a705c3d82372" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000007c75a705c3d82372 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Thank you Aaron for your reply and pointing me to the appropriate documentation. It turns out there is no preference file on my system, which is supposed to be a clean Debian 10.9 install. (Need to check with the servers team though). > I managed to change the apt repository for libpq5 by creating a pgdg preference file: *# cat /etc/apt/preferences.d/pgdg.pref* Package: * Pin: release o=3Dapt.postgresql.org Pin-Priority: 991 *# apt-cache policy libpq5* libpq5: Installed: (none) Candidate: 13.3-1.pgdg100+1 Version table: 13.3-1.pgdg100+1 991 991 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 While this is an improvement over manually installing the desired version of libpq5, I am still confused about why this pin-priority 990 is the default in my box. Thanks again for your support. Best regards, Fernando. El mi=C3=A9, 2 de jun. de 2021 a la(s) 23:48, Aaron Pavely (aaron@pavely.ne= t) escribi=C3=B3: > 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 >>>> 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 (>=3D 13.3) but 11.12-0+deb10u= 1 >>>> 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 i= t 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 priori= ties >>> 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_fr= om_this_repository > https://wiki.debian.org/AptConfiguration > > Aaron > --0000000000007c75a705c3d82372 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Thank you Aaron for your reply and pointing me to the appr= opriate documentation.
It turns out there is no preference file on my s= ystem, which is supposed to be a clean Debian 10.9 install. (Need to check = with the servers team though).

I managed to change the apt repository for libpq5 by creating a=20 pgdg preference file:

# cat /etc/apt/preferenc= es.d/pgdg.pref
Package: *
Pin: release o=3Dapt.postgresql.org
Pin-Priority: 991
<= /div>

# apt-cache policy libpq5
libpq5:
=C2= =A0 Installed: (none)
=C2=A0 Candidate: 13.3-1.pgdg100+1
=C2=A0 Versi= on table:
=C2=A0 =C2=A0 =C2=A013.3-1.pgdg100+1 991
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 991 http://a= pt.postgresql.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.debian.org/debian buster/m= ain amd64 Packages

While this is an improvemen= t over manually installing the desired version of libpq5, I am still confus= ed about why this pin-priority 990 is the default in my box.

=
Thanks again for your support.
Best regards,
=
Fernando.


El mi=C3=A9, 2 de jun. de 2021 a la(s) 2= 3:48, Aaron Pavely (aaron@pavely.net) escribi=C3=B3:
On Wed, Jun 2, 2021 at 9:11 PM Fernando Hev= ia <fhevia@gmail.c= om> wrote:
# apt-cache policy libpq5
libpq5:
=C2=A0 In= stalled: (none)
=C2=A0 Candidate: 11.12-0+deb10u1
=C2=A0 Version tabl= e:
=C2=A0 =C2=A0 =C2=A013.3-1.pgdg100+1 500
=C2=A0 =C2=A0 =C2=A0 =C2= =A0 500 http://apt.postgresql.org/pub/repos/apt buster-pgdg/main amd64 Packa= ges
=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 am= d64 Packages
=C2=A0 =C2=A0 =C2=A011.11-0+deb10u1 990
=C2=A0 =C2=A0 = =C2=A0 =C2=A0 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, Aar= on Pavely (aaron@pave= ly.net) escribi=C3=B3:
On Wed, Jun 2, 2021 at 6:47 PM Fernando Hevia <fhevia@gmail.com> wro= te:
Hi list.

As the subject states, I am facing an unme= t 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.l= ist.d/pgdg.list
deb http://apt.postgresql.org/pub/repos/apt buster-p= gdg main=C2=A0

# apt install=C2=A0postgresq= l-13=C2=A0postgresql-client-13
Reading package lists... Done<= br>Building dependency tree =C2=A0 =C2=A0 =C2=A0
Reading state informat= ion... 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
o= r been moved out of Incoming.
The following information may help to reso= lve the situation:

The following packages have unmet dependencies:=C2=A0postgresql-client-13 : Depends: libpq5 (>=3D 13.3) but 11.12-0+d= eb10u1 is to be installed
E: Unable to correct problems, you have held b= roken packages.

When looking for libpq5 availa= ble versions only v11.12 is listed.

# apt searc= h libpq5
Sorting... Done
Full Text Search... Done
libpq-dev/st= able 11.12-0+deb10u1 amd64
=C2=A0 header files for libpq5 (PostgreSQL li= brary)

libpq5/stable 11.12-0+deb10u1 amd64
=C2=A0 PostgreSQL C cl= ient library

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

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

Thanks,
Fernando.=C2=A0

Looks like there's a cross-over b= etween Debian's own repository and the PGDG repository. I suspect there= 's differing weights between the priorities for each. What's the re= sult of `apt-cache policy libpq5`?
Aaron
<= br>
Looks like your apt pinning=C2=A0policies for your Debian reposito= ries are set higher (990) than default (500). Is there a preference file ch= anging the default in `/etc/apt/preferences.d/`<= font face=3D"arial, sans-serif">?

=
Aaron
--0000000000007c75a705c3d82372--