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 <http://www.mokadb.com>
--
Adrian Klaver
adrian.klaver@aklaver.com
