On 2/1/23 07:54, Marc Millas wrote:
If I remember well, I did try all repo I ever heard off, and basic
Google search
Till I ask someone thru a postgis mailing list.
If you find something, like how to install a postgres 12 with a postgis
3.0 on any debian based distro.. Pls tell, I will read with interest.
Also, pls, not recompiling the whole thing with all associated libs ...
Thanks
Which was my customer requirelent
Using:
lsb_release -a
No LSB modules are available.
Distributor ID: Ubuntu
Description: Ubuntu 20.04.5 LTS
Release: 20.04
Codename: focal
and community repos:
deb http://apt.postgresql.org/pub/repos/apt focal-pgdg main
deb https://apt-archive.postgresql.org/pub/repos/apt focal-pgdg-archive main
sudo apt install postgresql-12
Success. You can now start the database server using:
pg_ctlcluster 12 main start
Then:
sudo apt list postgis -a
Listing... Done
postgis/focal-pgdg,focal-pgdg-archive 3.3.2+dfsg-1.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.3.1+dfsg-2.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.3.1+dfsg-1.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.3.0+dfsg-1.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.2.3+dfsg-1.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.2.2+dfsg-1.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.2.1+dfsg-1.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.2.0+dfsg-1.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.1.4+dfsg-3.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.1.4+dfsg-1.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.1.3+dfsg-1~exp1.pgdg20.04+1+b1 amd64
postgis/focal-pgdg-archive 3.1.2+dfsg-1~exp2.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.1.1+dfsg-1.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.1.0+dfsg-1.pgdg20.04+1 amd64
postgis/focal-pgdg-archive
3.1.0~alpha1+dfsg-1~exp2~232.gitc62f703.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.0.3+dfsg-2.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.0.2+dfsg-4.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.0.2+dfsg-2.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.0.1+dfsg-4.pgdg20.04+1 amd64
postgis/focal-pgdg-archive 3.0.1+dfsg-2.pgdg20.04+1 amd64
postgis/focal 3.0.0+dfsg-6ubuntu4 amd64
Followed by:
sudo apt install postgis=3.0.3+dfsg-2.pgdg20.04+1
...
After this operation, 234 MB of additional disk space will be used.
Do you want to continue? [Y/n] n
I did not actually install as I don't use PostGIS, so I would not know
how to verify a clean install.
This:
deb https://apt-archive.postgresql.org/pub/repos/apt focal-pgdg-archive main
comes from here:
https://www.df7cb.de/blog/2020/apt-archive.postgresql.org.html
The community packagers for deb packages have set up an archive repo for
older versions.
Le mar. 31 janv. 2023 à 17:38, Adrian Klaver <adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>> a écrit :
On 1/31/23 05:09, Marc Millas wrote:
> Sorry for inappropriate "reply".
>
> if you do check the debian postgis repo, you ll find that its NOT
> possible to choose a postgis version.
Are you talking about the repo hosted by Debian or the Postgres
community repo's here:
https://www.postgresql.org/download/linux/debian/
<https://www.postgresql.org/download/linux/debian/>
> its possible for postgis 2.4 and 2.5, then ALL 3.x versions are
> inaccessible but one, that did change from time to time.
> (you MUST ask for postgis 3 without being able to ask for 3.0 or 3.1
> or... its like asking for postgres 9 without .5 or .6)
> 2 of my customers reverse to a RH family linux because they have
been
> unable to install the requested postgres/postgis version on debian.
> when I did ask the team, the reply was: we cannot package for all
cross
> possibilities (ie. 5 postgres x 6 postgis, less some impossibilities
> according to postgis matrix)
>
> so...
>
>
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com <http://www.mokadb.com> <http://www.mokadb.com
<http://www.mokadb.com>>
>
>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
