Re: Missing libpq-dev version in buster-pgdg?

On 10/7/20 11:01 AM, Nick Aldwin wrote:
> Hi folks,
>
> Did something change recently with what versions of libpq-dev are
> published to buster-pgdg?  We have a dockerfile based on
> |postgres:12.2| (which is based on |buster-slim|) that installs
> |"libpq-dev=$PG_MAJOR.*"|  and it just recently (this week) started
> failing.  running a brand new postgres container and checking the apt
> cache, I only see versions for 11 (coming from debian sources) and 13
> (coming from buster-pgdg main).  I have verified that the sources list
> includes both |main| and |12| -- was it removed from |12|?

See this FAQ item:

https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_libpq5_for_version_X.2C_but_there_is_only_version_Y_in_the_repository

for how it works in the PGDG repos.

On the Debian side V11 is the supported version for Buster.

>
> $ docker run --rm -it --entrypoint bash postgres:12(dot)2root(at)fb7c949f82a0:/# apt update && apt-cache policy libpq-devGet:1http://deb.debian.org/debian buster InRelease [121 kB]
> Get:2http://security.debian.org/debian-security buster/updates InRelease [65.4 kB]
> Get:3http://deb.debian.org/debian buster-updates InRelease [51.9 kB]
> Get:4http://apt.postgresql.org/pub/repos/apt buster-pgdg InRelease [103 kB]
> Get:5http://security.debian.org/debian-security buster/updates/main amd64 Packages [233 kB]
> Get:6http://deb.debian.org/debian buster/main amd64 Packages [7,906 kB]
> Get:7http://deb.debian.org/debian buster-updates/main amd64 Packages [7,868 B]
> Get:8http://apt.postgresql.org/pub/repos/apt buster-pgdg/12 amd64 Packages [861 B]
> Get:9http://apt.postgresql.org/pub/repos/apt buster-pgdg/main amd64 Packages [203 kB]
> Fetched 8,694 kB in 2s (3,782 kB/s)
> Reading package lists... Done
> Building dependency tree
> Reading state information... Done
> 19 packages can be upgraded. Run 'apt list --upgradable' to see them.
> libpq-dev:
> Installed: (none)
> Candidate: 13.0-1.pgdg100+1
> Version table:
> 13.0-1.pgdg100+1 500
> 500http://apt.postgresql.org/pub/repos/apt buster-pgdg/main amd64 Packages
> 11.9-0+deb10u1 500
> 500http://deb.debian.org/debian buster/main amd64 Packages
> 11.7-0+deb10u1 500
> 500http://security.debian.org/debian-security buster/updates/main amd64 Packagesroot(at)fb7c949f82a0:/# cat /etc/apt/sources.list.d/pgdg.listdebhttp://apt.postgresql.org/pub/repos/apt/ buster-pgdg main 12
>
>
> Thanks,
> Nick

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com