Re: Best Open Source OS for Postgresql

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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com