Thread: postgis update wants to install postgresql-13
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? Best regards, Hubert
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 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
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