Re: postgis

On 7/20/22 07:21, Marc Millas wrote:
> Thanks for your answer.
> I would like to avoid compiling as much as possible.
> I know that postgis 3.2.1 is available and does install without pb. but..
> That db run an app which is very long to test, so I need to stick to a 
> postgis 3.0.x

Alright as close as could get. The procedure is:

1) Go to Postgres APT archive:

https://apt-archive.postgresql.org/

Add to you sources:

deb https://apt-archive.postgresql.org/pub/repos/apt 
bullseye-pgdg-archive main

Then:

sudo apt update

This will get you older versions of packages

2) Find package versions( I was doing this on Ubuntu 20.04 so the distro 
will be different from what you see):

apt list -a postgresql-12-postgis-3
Listing... Done
postgresql-12-postgis-3/focal-pgdg,focal-pgdg-archive 
3.2.1+dfsg-1.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.2.0+dfsg-1.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.1.4+dfsg-3.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.1.4+dfsg-1.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.1.3+dfsg-1~exp1.pgdg20.04+1 
amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.1.2+dfsg-1~exp2.pgdg20.04+1 
amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.1.1+dfsg-1.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.1.0+dfsg-1.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 
3.1.0~alpha1+dfsg-1~exp2~232.gitc62f703.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.0.3+dfsg-2.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.0.2+dfsg-4.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.0.2+dfsg-2.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.0.1+dfsg-4.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal-pgdg-archive 3.0.1+dfsg-2.pgdg20.04+1 amd64
postgresql-12-postgis-3/focal 3.0.0+dfsg-6ubuntu4 amd64

3) From above the latest 3.0.x is 3.0.3. So then do:

sudo apt install  postgresql-12-postgis-3=3.0.3+dfsg-2.pgdg20.04+1


On my machine it installed PostGIS 3.0.3 with no issues.

> 
> regards,
> 
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com 


-- 
Adrian Klaver
adrian.klaver@aklaver.com