Обсуждение: Best Open Source OS for Postgresql
Cordiali Saluti - Best Regards
Dott. Giovanni Biscontini
[Divisone Software]
____________________________________
Privacy e riservatezza: il presente messaggio, così come i relativi allegati, contengono dati ed informazioni da considerarsi strettamente riservate ed è indirizzato esclusivamente al destinatario sopra indicato, il quale è l'unico autorizzato a trattarlo in osservanza delle norme del Regolamento UE 2016/679 (RGPD) . Preghiamo chiunque ricevesse questo messaggio per errore di evitare di copiarlo, divulgarlo, distribuirlo a terzi e di dare notizia al mittente dell’errato invio, distruggendone poi l'eventuale copia cartacea e la copia in formato elettronico.
Il titolare dei dati potrà esercitare tutti i diritti di cui all'art.7 del suddetto decreto tra cui quelli di accesso, rettifica, aggiornamento, opposizione al trattamento e cancellazione
Please, print this e-mail only if necessary
From 2019, I've been using AlmaLinux from version 8.4 up to now version 8.7. This January, I've been trying to upgrade PostgreSQL from v14.6 to v15.1.
Error: Transaction test error: file /usr/lib/.build-id/a0/a43182caa55ed9d3562e2d9b74a1dda150e2c4 from install of ogr_fdw_15-1.1.3-1.rhel8.x86_64 conflicts with file from package ogr_fdw_14-1.1.3-1.rhel8.x86_64
May be someone here on this mailing-list have access to the package manager that build the ogr_fdw_14 and ogr_fdw_15 package, and release the package update to resolve the conflicted file, I'll be waiting for the package release update before I rollout the update to my production server.
Hello everyone,we're looking for a Open Source alternative to Rhel for our VM server dedicated to Postgresql (14->15) installations. We're testing Alma, Rocky, and Oracle distributions as they're compatible with Rhel package systems.Can you share your experience on a similar choice?Thanks in advance and best regards, Giovanni--
Cordiali Saluti - Best Regards
Dott. Giovanni Biscontini
[Divisone Software]
____________________________________
Privacy e riservatezza: il presente messaggio, così come i relativi allegati, contengono dati ed informazioni da considerarsi strettamente riservate ed è indirizzato esclusivamente al destinatario sopra indicato, il quale è l'unico autorizzato a trattarlo in osservanza delle norme del Regolamento UE 2016/679 (RGPD) . Preghiamo chiunque ricevesse questo messaggio per errore di evitare di copiarlo, divulgarlo, distribuirlo a terzi e di dare notizia al mittente dell’errato invio, distruggendone poi l'eventuale copia cartacea e la copia in formato elettronico.
Il titolare dei dati potrà esercitare tutti i diritti di cui all'art.7 del suddetto decreto tra cui quelli di accesso, rettifica, aggiornamento, opposizione al trattamento e cancellazione
Please, print this e-mail only if necessary
On Tue, Jan 31, 2023 at 09:02:53AM +0100, Giovanni Biscontini wrote: > Hello everyone, > we're looking for a Open Source alternative to Rhel for our VM server > dedicated to Postgresql (14->15) installations. We're testing Alma, Rocky, > and Oracle distributions as they're compatible with Rhel package systems. > Can you share your experience on a similar choice? > Thanks in advance and best regards, Giovanni It will be os that you know. I, for one, love all things debian based, so I tend to use debian or ubuntu. It helps that the Pg apt repo is absolutely AMAZING. depesz
On Tue, Jan 31, 2023 at 01:18:08PM +0100, Marc Millas wrote: > Did you check postgis debian repo? ?? Not sure why: 1. you ask me that 2. you ask me that off list but no, i haven't. depesz
On Tue, Jan 31, 2023 at 01:18:08PM +0100, Marc Millas wrote:
> Did you check postgis debian repo? ??
Not sure why:
1. you ask me that
2. you ask me that off list
but no, i haven't.
depesz
On Tue, Jan 31, 2023 at 02:09:40PM +0100, Marc Millas wrote: > if you do check the debian postgis repo, you ll find that its NOT possible > to choose a postgis version. > 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) While this is definitely a factor that has to be considered, OP never said anything about postgis. So, while it is perfectly possible that they do, and they have to stick to some version that is not available in debian/ubuntu, it kinda seems like a jump to assume that. Best regards, depesz
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/ > 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> > > -- Adrian Klaver adrian.klaver@aklaver.com
On Wed, 1 Feb 2023 at 08:04, Tony Shelver <tshelver@gmail.com> wrote:On Tue, 31 Jan 2023 at 15:10, Marc Millas <marc.millas@mokadb.com> 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.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)Maybe I am not understanding this, but have you checked the UbuntuGIS source? I know not pure Debian, but...Sent before complete:UbuntuGIS stable shows PostGIS 2.4 and 2.5 available, as well as 3.1 and 3.2 : https://launchpad.net/%7Eubuntugis/+archive/ubuntu/ppa/+index?batch=75&memo=75&start=75Also note that UbuntuGIS is based off the DebianGIS project: https://wiki.debian.org/DebianGisWe run both Ubuntu and Centos servers. The change to Centos licensing has led us to support it only for one specific application that is embedded in Centos that we are trying to end-of-life ASAP. At least Ubuntu server has a 5 year support window, and Ubuntu has now announced a limited 'free' Pro option for smaller businesses that provides a 10 year window.Regards
Not sure why: 2. you ask me that off list
Brad.
On-call IT Management for small companies and non-profits.
SCP, Inc.
bwhite@inebraska.com
402-601-7990
Quote of the Day
Principal Technician, Fisheries
NIWA
DDI: +64 (4) 3860529
Sent: Wednesday, February 1, 2023 19:19
To: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: Re: Best Open Source OS for Postgresql
On Wed, 1 Feb 2023 at 08:04, Tony Shelver <tshelver@gmail.com> wrote:On Tue, 31 Jan 2023 at 15:10, Marc Millas <marc.millas@mokadb.com> 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.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)Maybe I am not understanding this, but have you checked the UbuntuGIS source? I know not pure Debian, but...Sent before complete:UbuntuGIS stable shows PostGIS 2.4 and 2.5 available, as well as 3.1 and 3.2 : https://launchpad.net/%7Eubuntugis/+archive/ubuntu/ppa/+index?batch=75&memo=75&start=75Also note that UbuntuGIS is based off the DebianGIS project: https://wiki.debian.org/DebianGisWe run both Ubuntu and Centos servers. The change to Centos licensing has led us to support it only for one specific application that is embedded in Centos that we are trying to end-of-life ASAP. At least Ubuntu server has a 5 year support window, and Ubuntu has now announced a limited 'free' Pro option for smaller businesses that provides a 10 year window.Regards
![]() |
I would suggest any major Ubuntu based distro, I have a personal preference for Mint.I'd also suggest you set up the official Postgres repo, rather than using a distro repo, so your installs come directly from there.
Copied to the listOn Wed, 1 Feb 2023 at 08:18, Tony Shelver <tshelver@gmail.com> wrote:On Wed, 1 Feb 2023 at 08:04, Tony Shelver <tshelver@gmail.com> wrote:On Tue, 31 Jan 2023 at 15:10, Marc Millas <marc.millas@mokadb.com> 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.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)Maybe I am not understanding this, but have you checked the UbuntuGIS source? I know not pure Debian, but...Sent before complete:UbuntuGIS stable shows PostGIS 2.4 and 2.5 available, as well as 3.1 and 3.2 : https://launchpad.net/%7Eubuntugis/+archive/ubuntu/ppa/+index?batch=75&memo=75&start=75Also note that UbuntuGIS is based off the DebianGIS project: https://wiki.debian.org/DebianGisWe run both Ubuntu and Centos servers. The change to Centos licensing has led us to support it only for one specific application that is embedded in Centos that we are trying to end-of-life ASAP. At least Ubuntu server has a 5 year support window, and Ubuntu has now announced a limited 'free' Pro option for smaller businesses that provides a 10 year window.Regards
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/
> 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>
>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
We're looking for a Open Source alternative to Rhel for our VM server dedicated to Postgresql (14->15) installations. We're testing Alma, Rocky, and Oracle distributions as they're compatible with Rhel package systems.Can you share your experience on a similar choice?
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
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
On 2/1/23 9:22 AM, Bob Jolliffe wrote: > 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. It is a big program that covers a lot of ground. What is disconcerting is that you see the dependencies called out instead of being wrapped into a blob. Not going to make much difference to the dependencies but this: sudo apt install postgis=3.0.3+dfsg-2.pgdg20.04+1 should actually be: sudo apt install postgresql-12-postgis-3=3.0.3+dfsg-2.pgdg20.04+1 The first form has a dependency on the latest Postgres, so will want to install Postgres 15. > > Regards > Bob > -- Adrian Klaver adrian.klaver@aklaver.com