postgis update wants to install postgresql-13

[Hu Bert]

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

Re: postgis update wants to install postgresql-13

[Hu Bert]

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
:
>
> 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.kla...@aklaver.com

After upgrade pg12 -> pg14 import time increased

[Hu Bert]

Hello,

starting with an explanation first... i have some sort of 'cold
backup' system: it rsyncs a postgres dump (size: ~1.5TB) from the main
system (created with 'pg_dump $dbname > db.sql) to the backup system
(10TB hdds in a raid10), and then automatically imports that dump
(psql $dbname < $db.sql) into postgres. So the backup system
stores/provides the database of each day (cleanup of older stuff done
manually). copy+import normally finished within 16-18 hours.

About 4 weeks ago both systems were running with postgres12 on debian
buster; then the switch to postgres14 was done, first on main system,
later on the backup system (both with pg_upgrade, no problems here).
But after that switch the import time on the backup system increased,
now taking more than 24 hours. A dist-upgrade to debian bullseye was
done, but no improvement.

I was checking release notes (releases 13+14), but, somehow, nothing
catched my eye.

hardware of backup system:
128G ram, raid10 (ext4, 4 disks) for postgresql, raid10 (ext4, 6
disks) for sql backup files
shared_buffers = 32768MB
work_mem = 16384MB
maintenance_work_mem = 16384MB
effective_cache_size = 16GB

no read/write operations on the backup system. any idea what could've
changed? more information needed?

thx,
Hubert