Re: postgis

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Marc Millas <marc(dot)millas(at)mokadb(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: postgis
Date: 2022-07-20 16:14:04
Message-ID: 0071e345-a9b5-2742-6560-0d43a08304ea@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2022-07-20 16:16:17 Re: postgis
Previous Message David G. Johnston 2022-07-20 15:55:14 Re: postgis