Re: Best Open Source OS for Postgresql

I have generally favoured ubuntu LTS editions over the years, more out of
familiarity than any particular good technical reason. In the past,
postgresql on FreeBSD would have been my first goto, but it's harder to get
freebsd skills out on the market than ubuntu/debian linux.

I do have one gripe about the packaged postgis packages : the list of
dependencies seem quite enormous. For example, the previous poster
mentions 234MB. I find the list of dependencies a little baffling and
disconcerting.

Regards
Bob

On Wed, 1 Feb 2023 at 16:25, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> 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
>
>
>
>