postgis update wants to install postgresql-13

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

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 10:53 PM, Hu Bert wrote:

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.

Yeah it seems:

postgis/buster-pgdg 3.0.2+dfsg-4.pgdg100+1 amd64 [upgradable from:
3.0.2+dfsg-2.pgdg100+1]

has introduced a dependency on Postgres 13.

That is something the packagers would need to answer. You can try at
Contact here:

https://wiki.postgresql.org/wiki/Apt#Contact

Or by filing an issue here:

https://redmine.postgresql.org/projects/pgapt/issues

FYI, for the above you will need a community account.

Best regards,
Hubert

--
Adrian Klaver
adrian.klaver@aklaver.com