public inbox for [email protected]  
help / color / mirror / Atom feed
Postgres 13 package on Debian 10 has unmet dependencies
5+ messages / 2 participants
[nested] [flat]

* Postgres 13 package on Debian 10 has unmet dependencies
@ 2021-06-02 23:47 Fernando Hevia <[email protected]>
  2021-06-03 00:54 ` Re: Postgres 13 package on Debian 10 has unmet dependencies Aaron Pavely <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Fernando Hevia @ 2021-06-02 23:47 UTC (permalink / raw)
  To: [email protected]

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.


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postgres 13 package on Debian 10 has unmet dependencies
  2021-06-02 23:47 Postgres 13 package on Debian 10 has unmet dependencies Fernando Hevia <[email protected]>
@ 2021-06-03 00:54 ` Aaron Pavely <[email protected]>
  2021-06-03 02:11   ` Re: Postgres 13 package on Debian 10 has unmet dependencies Fernando Hevia <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Aaron Pavely @ 2021-06-03 00:54 UTC (permalink / raw)
  To: Fernando Hevia <[email protected]>; +Cc: [email protected]

On Wed, Jun 2, 2021 at 6:47 PM Fernando Hevia <[email protected]> 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


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postgres 13 package on Debian 10 has unmet dependencies
  2021-06-02 23:47 Postgres 13 package on Debian 10 has unmet dependencies Fernando Hevia <[email protected]>
  2021-06-03 00:54 ` Re: Postgres 13 package on Debian 10 has unmet dependencies Aaron Pavely <[email protected]>
@ 2021-06-03 02:11   ` Fernando Hevia <[email protected]>
  2021-06-03 02:48     ` Re: Postgres 13 package on Debian 10 has unmet dependencies Aaron Pavely <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Fernando Hevia @ 2021-06-03 02:11 UTC (permalink / raw)
  To: Aaron Pavely <[email protected]>; +Cc: [email protected]

*# 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 ([email protected])
escribió:

> On Wed, Jun 2, 2021 at 6:47 PM Fernando Hevia <[email protected]> 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
>


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postgres 13 package on Debian 10 has unmet dependencies
  2021-06-02 23:47 Postgres 13 package on Debian 10 has unmet dependencies Fernando Hevia <[email protected]>
  2021-06-03 00:54 ` Re: Postgres 13 package on Debian 10 has unmet dependencies Aaron Pavely <[email protected]>
  2021-06-03 02:11   ` Re: Postgres 13 package on Debian 10 has unmet dependencies Fernando Hevia <[email protected]>
@ 2021-06-03 02:48     ` Aaron Pavely <[email protected]>
  2021-06-03 08:12       ` Re: Postgres 13 package on Debian 10 has unmet dependencies Fernando Hevia <[email protected]>
  0 siblings, 1 reply; 5+ messages in thread

From: Aaron Pavely @ 2021-06-03 02:48 UTC (permalink / raw)
  To: Fernando Hevia <[email protected]>; +Cc: [email protected]

On Wed, Jun 2, 2021 at 9:11 PM Fernando Hevia <[email protected]> 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 ([email protected])
> escribió:
>
>> On Wed, Jun 2, 2021 at 6:47 PM Fernando Hevia <[email protected]> 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


^ permalink  raw  reply  [nested|flat] 5+ messages in thread

* Re: Postgres 13 package on Debian 10 has unmet dependencies
  2021-06-02 23:47 Postgres 13 package on Debian 10 has unmet dependencies Fernando Hevia <[email protected]>
  2021-06-03 00:54 ` Re: Postgres 13 package on Debian 10 has unmet dependencies Aaron Pavely <[email protected]>
  2021-06-03 02:11   ` Re: Postgres 13 package on Debian 10 has unmet dependencies Fernando Hevia <[email protected]>
  2021-06-03 02:48     ` Re: Postgres 13 package on Debian 10 has unmet dependencies Aaron Pavely <[email protected]>
@ 2021-06-03 08:12       ` Fernando Hevia <[email protected]>
  0 siblings, 0 replies; 5+ messages in thread

From: Fernando Hevia @ 2021-06-03 08:12 UTC (permalink / raw)
  To: Aaron Pavely <[email protected]>; +Cc: [email protected]

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=apt.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é, 2 de jun. de 2021 a la(s) 23:48, Aaron Pavely ([email protected])
escribió:

> On Wed, Jun 2, 2021 at 9:11 PM Fernando Hevia <[email protected]> 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 ([email protected])
>> escribió:
>>
>>> On Wed, Jun 2, 2021 at 6:47 PM Fernando Hevia <[email protected]> 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
>


^ permalink  raw  reply  [nested|flat] 5+ messages in thread


end of thread, other threads:[~2021-06-03 08:12 UTC | newest]

Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-06-02 23:47 Postgres 13 package on Debian 10 has unmet dependencies Fernando Hevia <[email protected]>
2021-06-03 00:54 ` Aaron Pavely <[email protected]>
2021-06-03 02:11   ` Fernando Hevia <[email protected]>
2021-06-03 02:48     ` Aaron Pavely <[email protected]>
2021-06-03 08:12       ` Fernando Hevia <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox