Re: postgis update wants to install postgresql-13 - Mailing list pgsql-general

Hi Adrian,

thx for your answer. I checked all the relevant & installed packages:

hi  postgis                           3.0.2+dfsg-2.pgdg100+1
ii  postgis-doc                       3.0.2+dfsg-2.pgdg100+1
ii  postgresql-12                     12.4-1.pgdg100+1
ii  postgresql-12-postgis-2.5         2.5.5+dfsg-1.pgdg100+1
ii  postgresql-12-postgis-2.5-scripts 2.5.5+dfsg-1.pgdg100+1
ii  postgresql-12-postgis-3           3.0.2+dfsg-2.pgdg100+1
ii  postgresql-12-postgis-3-scripts   3.0.2+dfsg-2.pgdg100+1
ii  postgresql-client-12              12.4-1.pgdg100+1
ii  postgresql-client-common          217.pgdg100+1
ii  postgresql-common                 217.pgdg100+1

None of these 3 meta packages is installed. So i wonder why
postgresql-13 will be installed though. I have another server with
postgresql installed; packages there:

ii  postgresql-12                     12.4-1.pgdg100+1
ii  postgresql-12-postgis-2.5         2.5.5+dfsg-1.pgdg100+1
ii  postgresql-12-postgis-2.5-scripts 2.5.5+dfsg-1.pgdg100+1
ii  postgresql-client-12              12.4-1.pgdg100+1
ii  postgresql-client-common          216.pgdg100+1
ii  postgresql-common                 216.pgdg100+1

Debian buster as well, same packages. Difference: only postgis &
postgresql-12-postgis-3 & postgresql-12-postgis-3-scripts packages are
missing, but with 'apt update && apt upgrade' no postgresql-13 will be
installed.

For the moment i set the postgis package on hold, and the effect is:
no postgresql-13 update/upgrade. Strange.


Best regards,
Hubert

Am Mo., 26. Okt. 2020 um 19:28 Uhr schrieb Adrian Klaver
<adrian.klaver@aklaver.com>:
>
> On 10/26/20 6:34 AM, Hu Bert wrote:
> > Hi there,
> >
> > i hope i'm right here... i just wanted to install some debian updates
> > (buster) and saw that there are postgres/postgis updates as well.
> > Currently installed:
> >
> > postgis                           3.0.2+dfsg-2.pgdg100+1
> > postgis-doc                       3.0.2+dfsg-2.pgdg100+1
> > postgresql-12                     12.4-1.pgdg100+1
> > postgresql-12-postgis-2.5         2.5.5+dfsg-1.pgdg100+1
> > postgresql-12-postgis-2.5-scripts 2.5.5+dfsg-1.pgdg100+1
> > postgresql-12-postgis-3           3.0.2+dfsg-2.pgdg100+1
> > postgresql-12-postgis-3-scripts   3.0.2+dfsg-2.pgdg100+1
> >
> > I use postgis extension in v2.5. The postgis package is needed for
> > shp2pgsql etc. Upgradeable packages are:
> >
> > postgis-doc/buster-pgdg 3.0.2+dfsg-4.pgdg100+1 all [upgradable from:
> > 3.0.2+dfsg-2.pgdg100+1]
> > postgis/buster-pgdg 3.0.2+dfsg-4.pgdg100+1 amd64 [upgradable from:
> > 3.0.2+dfsg-2.pgdg100+1]
> > postgresql-12-postgis-3-scripts/buster-pgdg 3.0.2+dfsg-4.pgdg100+1 all
> > [upgradable from: 3.0.2+dfsg-2.pgdg100+1]
> > postgresql-12-postgis-3/buster-pgdg 3.0.2+dfsg-4.pgdg100+1 amd64
> > [upgradable from: 3.0.2+dfsg-2.pgdg100+1]
> > postgresql-client-common/buster-pgdg 220.pgdg100+1 all [upgradable
> > from: 217.pgdg100+1]
> > postgresql-common/buster-pgdg 220.pgdg100+1 all [upgradable from: 217.pgdg100+1]
> >
> > But there are some unexpected packages to be installed:
> >
> > The following NEW packages will be installed:
> >   postgresql-13 postgresql-13-postgis-3 postgresql-13-postgis-3-scripts
> > postgresql-client-13
> >
> > If i get it right for the minor postgis update now postgresql-13 will
> > be installed. Is there any reason for this?
>
> Yes:
>
> https://wiki.postgresql.org/wiki/Apt
>
> "Note: This repository provides "postgresql", "postgresql-contrib", and
> "postgresql-client" meta-packages that depend on the latest
> postgresql-x.y, ... packages, similar to the ones present in Debian and
> Ubuntu. Once a new PostgreSQL version is released, these meta-packages
> will be updated to depend on the new version. If you rather want to stay
> with a particular PostgreSQL version, you should install specific
> packages like "postgresql-11" instead of "postgresql". "
>
> >
> >
> > Best regards,
> > Hubert
> >
> >
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com