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

Hi Adrian,

The FAQ you linked to says the following:

> If you really want to use a different version, the packages are available
in separate archive components named after the PostgreSQL major version.
Append that version after "main" in your sources.list. For example, if you
wanted 9.0's libpq5 on Debian Squeeze, use this: deb
http://apt.postgresql.org/pub/repos/apt/ squeeze-pgdg main *9.0*

In the postgres dockerfile, it _is_ appending the version 12 to the sources
list:

root(at)fb7c949f82a0:/# cat /etc/apt/sources.list.d/pgdg.list

deb http://apt.postgresql.org/pub/repos/apt/ buster-pgdg main 12

However I am still not seeing that version show up. If I remove 'main',
leaving just 12, no versions show up as coming from the postgres repo at
all. Am I missing something else here?

-Nick

On Wed, Oct 7, 2020 at 2:56 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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:1
> http://deb.debian.org/debian
> buster InRelease [121 kB]
> > Get:2
> http://security.debian.org/debian-security
> buster/updates InRelease [65.4 kB]
> > Get:3
> http://deb.debian.org/debian
> buster-updates InRelease [51.9 kB]
> > Get:4
> http://apt.postgresql.org/pub/repos/apt
> buster-pgdg InRelease [103 kB]
> > Get:5
> http://security.debian.org/debian-security
> buster/updates/main amd64 Packages [233 kB]
> > Get:6
> http://deb.debian.org/debian
> buster/main amd64 Packages [7,906 kB]
> > Get:7
> http://deb.debian.org/debian
> buster-updates/main amd64 Packages [7,868 B]
> > Get:8
> http://apt.postgresql.org/pub/repos/apt
> buster-pgdg/12 amd64 Packages [861 B]
> > Get:9
> http://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
> > 500
> http://apt.postgresql.org/pub/repos/apt
> buster-pgdg/main amd64 Packages
> > 11.9-0+deb10u1 500
> > 500
> http://deb.debian.org/debian
> buster/main amd64 Packages
> > 11.7-0+deb10u1 500
> > 500
> http://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
>
>
>