Re: Best Open Source OS for Postgresql - Mailing list pgsql-general

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@aklaver.com 
> <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com