pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Best Open Source OS for Postgresql
17+ messages / 11 participants
[nested] [flat]

* Best Open Source OS for Postgresql
@ 2023-01-31 08:02 Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 11:59 ` Re: Best Open Source OS for Postgresql Surya Widyanto <ayrus02@gmail.com>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-02-01 16:05 ` Re: Best Open Source OS for Postgresql Jeffrey Walton <noloader@gmail.com>
  0 siblings, 3 replies; 17+ messages in thread

From: Giovanni Biscontini @ 2023-01-31 08:02 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

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



  WEB: https://www.es2000.it <http://www.es2000.it/;







____________________________________

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*

^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
@ 2023-01-31 11:59 ` Surya Widyanto <ayrus02@gmail.com>
  2 siblings, 0 replies; 17+ messages in thread

From: Surya Widyanto @ 2023-01-31 11:59 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

Hi,

 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.
When I install PostgreSQL v14.6 along side with v15.1 in the same 
server, it run without trouble at all, but because I'm using the PostGIS 
extension, there is one package *ogr_fdw_14 *than cannot be along side 
with the *ogr_fdw_15 *version, specifically on this file:

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

because of this problem, I'm currently stuck on upgrading the PostgreSQL 
to v15.1. Last week, on my development server I can install the 
*ogr_fdw_15 *on by using manual extraction of the RPM package to each 
individual directory with exception the conflicted file, and the 
extension is successfully installed and detected on the PostgreSQL 
v15.1.  Next weekend, I planned on upgrading the production server to 
v15.1 using the same method, unless anyone here can show me other method 
than manually extracting the RPM package.

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.

Best Regards,
Surya Widyanto


On 31-01-2023 15:02, 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
>
> -- 
>
> *Cordiali Saluti - Best Regards*
>
>
> ***Dott. Giovanni Biscontini*
>
> * [Divisone Software]*
>
> **WEB: https://www.es2000.it <http://www.es2000.it/;
>
> ____________________________________
>
> 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*
>

^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
@ 2023-01-31 12:06 ` hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2 siblings, 1 reply; 17+ messages in thread

From: hubert depesz lubaczewski @ 2023-01-31 12:06 UTC (permalink / raw)
  To: Giovanni Biscontini <biscontini.g@es2000.it>; +Cc: pgsql-general@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
@ 2023-01-31 12:23   ` hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2023-02-01 06:39     ` Re: Best Open Source OS for Postgresql Brad White <b55white@gmail.com>
  0 siblings, 2 replies; 17+ messages in thread

From: hubert depesz lubaczewski @ 2023-01-31 12:23 UTC (permalink / raw)
  To: Marc Millas <marc.millas@mokadb.com>; +Cc: pgsql-general

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





^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
@ 2023-01-31 13:09     ` Marc Millas <marc.millas@mokadb.com>
  2023-01-31 13:21       ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 16:38       ` Re: Best Open Source OS for Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
  2023-02-01 06:19       ` Re: Best Open Source OS for Postgresql Tony Shelver <tshelver@gmail.com>
  1 sibling, 3 replies; 17+ messages in thread

From: Marc Millas @ 2023-01-31 13:09 UTC (permalink / raw)
  To: depesz@depesz.com; +Cc: pgsql-general

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)

so...


Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com



On Tue, Jan 31, 2023 at 1:23 PM hubert depesz lubaczewski <depesz@depesz.com>
wrote:

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

^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
@ 2023-01-31 13:21       ` hubert depesz lubaczewski <depesz@depesz.com>
  2 siblings, 0 replies; 17+ messages in thread

From: hubert depesz lubaczewski @ 2023-01-31 13:21 UTC (permalink / raw)
  To: Marc Millas <marc.millas@mokadb.com>; +Cc: pgsql-general

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






^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
@ 2023-01-31 16:38       ` Adrian Klaver <adrian.klaver@aklaver.com>
  2023-02-01 15:54         ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2 siblings, 1 reply; 17+ messages in thread

From: Adrian Klaver @ 2023-01-31 16:38 UTC (permalink / raw)
  To: Marc Millas <marc.millas@mokadb.com>; depesz@depesz.com; +Cc: pgsql-general

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






^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2023-01-31 16:38       ` Re: Best Open Source OS for Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-02-01 15:54         ` Marc Millas <marc.millas@mokadb.com>
  2023-02-01 16:25           ` Re: Best Open Source OS for Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 1 reply; 17+ messages in thread

From: Marc Millas @ 2023-02-01 15:54 UTC (permalink / raw)
  To: Adrian Klaver <adrian.klaver@aklaver.com>; +Cc: pgsql-general

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

Le mar. 31 janv. 2023 à 17:38, Adrian Klaver <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/
>
> > 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
>
>

^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2023-01-31 16:38       ` Re: Best Open Source OS for Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
  2023-02-01 15:54         ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
@ 2023-02-01 16:25           ` Adrian Klaver <adrian.klaver@aklaver.com>
  2023-02-01 17:22             ` Re: Best Open Source OS for Postgresql Bob Jolliffe <bobjolliffe@gmail.com>
  0 siblings, 1 reply; 17+ messages in thread

From: Adrian Klaver @ 2023-02-01 16:25 UTC (permalink / raw)
  To: Marc Millas <marc.millas@mokadb.com>; +Cc: 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






^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2023-01-31 16:38       ` Re: Best Open Source OS for Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
  2023-02-01 15:54         ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2023-02-01 16:25           ` Re: Best Open Source OS for Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
@ 2023-02-01 17:22             ` Bob Jolliffe <bobjolliffe@gmail.com>
  2023-02-01 18:53               ` Re: Best Open Source OS for Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 1 reply; 17+ messages in thread

From: Bob Jolliffe @ 2023-02-01 17:22 UTC (permalink / raw)
  To: pgsql-general; +Cc: Marc Millas <marc.millas@mokadb.com>; depesz@depesz.com

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.klaver@aklaver.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.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
>
>
>
>

^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2023-01-31 16:38       ` Re: Best Open Source OS for Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
  2023-02-01 15:54         ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2023-02-01 16:25           ` Re: Best Open Source OS for Postgresql Adrian Klaver <adrian.klaver@aklaver.com>
  2023-02-01 17:22             ` Re: Best Open Source OS for Postgresql Bob Jolliffe <bobjolliffe@gmail.com>
@ 2023-02-01 18:53               ` Adrian Klaver <adrian.klaver@aklaver.com>
  0 siblings, 0 replies; 17+ messages in thread

From: Adrian Klaver @ 2023-02-01 18:53 UTC (permalink / raw)
  To: Bob Jolliffe <bobjolliffe@gmail.com>; pgsql-general; +Cc: Marc Millas <marc.millas@mokadb.com>; depesz@depesz.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





^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
@ 2023-02-01 06:19       ` Tony Shelver <tshelver@gmail.com>
  2023-02-01 06:45         ` Re: Best Open Source OS for Postgresql Brent Wood <Brent.Wood@niwa.co.nz>
  2023-02-01 15:39         ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2 siblings, 2 replies; 17+ messages in thread

From: Tony Shelver @ 2023-02-01 06:19 UTC (permalink / raw)
  To: pgsql-general <pgsql-general@lists.postgresql.org>

Copied to the list
On 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=75
> Got this link from https://wiki.ubuntu.com/UbuntuGIS  via
> https://postgis.net/install/
> Also note that UbuntuGIS is based off the DebianGIS project:
> https://wiki.debian.org/DebianGis
>
> We 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
>
>
>>

^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2023-02-01 06:19       ` Re: Best Open Source OS for Postgresql Tony Shelver <tshelver@gmail.com>
@ 2023-02-01 06:45         ` Brent Wood <Brent.Wood@niwa.co.nz>
  2023-02-01 15:21           ` Re: Best Open Source OS for Postgresql Wim Bertels <wim.bertels@ucll.be>
  1 sibling, 1 reply; 17+ messages in thread

From: Brent Wood @ 2023-02-01 06:45 UTC (permalink / raw)
  To: pgsql-general <pgsql-general@lists.postgresql.org>

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.

https://wiki.postgresql.org/wiki/Apt


Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529
________________________________
From: Tony Shelver <tshelver@gmail.com>
Sent: Wednesday, February 1, 2023 19:19
To: pgsql-general <pgsql-general@lists.postgresql.org>
Subject: Re: Best Open Source OS for Postgresql


Copied to the list
On Wed, 1 Feb 2023 at 08:18, Tony Shelver <tshelver@gmail.com<mailto:tshelver@gmail.com>> wrote:


On Wed, 1 Feb 2023 at 08:04, Tony Shelver <tshelver@gmail.com<mailto:tshelver@gmail.com>> wrote:

On Tue, 31 Jan 2023 at 15:10, Marc Millas <marc.millas@mokadb.com<mailto: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=75<h...;
Got this link from https://wiki.ubuntu.com/UbuntuGIS<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F...;  via  https://postgis.net/install/<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpo...;
Also note that UbuntuGIS is based off the DebianGIS project: https://wiki.debian.org/DebianGis<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F...;

We 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


[https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] <https://www.niwa.co.nz;
Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz<https://www.niwa.co.nz; Facebook<https://www.facebook.com/nzniwa; LinkedIn<https://www.linkedin.com/company/niwa; Twitter<https://twitter.com/niwa_nz; Instagram<https://www.instagram.com/niwa_science;
To ensure compliance with legal requirements and to maintain cyber security standards, NIWA's IT systems are subject to ongoing monitoring, activity logging and auditing. This monitoring and auditing service may be provided by third parties. Such third parties can access information transmitted to, processed by and stored on NIWA's IT systems

^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2023-02-01 06:19       ` Re: Best Open Source OS for Postgresql Tony Shelver <tshelver@gmail.com>
  2023-02-01 06:45         ` Re: Best Open Source OS for Postgresql Brent Wood <Brent.Wood@niwa.co.nz>
@ 2023-02-01 15:21           ` Wim Bertels <wim.bertels@ucll.be>
  0 siblings, 0 replies; 17+ messages in thread

From: Wim Bertels @ 2023-02-01 15:21 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; +Cc: biscontini.g@es2000.it <biscontini.g@es2000.it>

Hello Giovanni,

it depends,
do you know a truly open source os without proprietary blobs for firmware or device drivers?

Debian used to try to make a clear separation in this with 'main' being the default section when installing,
unfortunately this practically no longer applies to proprietary firmware if i understand it correctly, unless you check yourself:
https://www.debian.org/vote/2022/vote_003
vs before:
https://www.debian.org/releases/squeeze/i386/release-notes/ch-whats-new.en.html#nonfree-firmware
which i guess is still the case?, but now it gets loaded/installed by default
(easy functionality over open source)

I would choose a distro with LTS (long term support),
as the last post mentions Ubuntu and Mint,
this would only apply to Ubuntu LTS (or up in the family tree Debian LTS)

i have had good experiences with the link from Brent,
but i imagine other serious LTS distros should work well as well

hth,
Wim

Brent Wood schreef op wo 01-02-2023 om 06:45 [+0000]:
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.

https://wiki.postgresql.org/wiki/Apt






^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 13:09     ` Re: Best Open Source OS for Postgresql Marc Millas <marc.millas@mokadb.com>
  2023-02-01 06:19       ` Re: Best Open Source OS for Postgresql Tony Shelver <tshelver@gmail.com>
@ 2023-02-01 15:39         ` Marc Millas <marc.millas@mokadb.com>
  1 sibling, 0 replies; 17+ messages in thread

From: Marc Millas @ 2023-02-01 15:39 UTC (permalink / raw)
  To: Tony Shelver <tshelver@gmail.com>; +Cc: pgsql-general <pgsql-general@lists.postgresql.org>

Hello,
What about postgis :
3.0,
3.3,
3.4
??

Le mer. 1 févr. 2023 à 07:20, Tony Shelver <tshelver@gmail.com> a écrit :

>
> Copied to the list
> On 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=75
>> Got this link from https://wiki.ubuntu.com/UbuntuGIS  via
>> https://postgis.net/install/
>> Also note that UbuntuGIS is based off the DebianGIS project:
>> https://wiki.debian.org/DebianGis
>>
>> We 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
>>
>>
>>>

^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
  2023-01-31 12:06 ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
  2023-01-31 12:23   ` Re: Best Open Source OS for Postgresql hubert depesz lubaczewski <depesz@depesz.com>
@ 2023-02-01 06:39     ` Brad White <b55white@gmail.com>
  1 sibling, 0 replies; 17+ messages in thread

From: Brad White @ 2023-02-01 06:39 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

On 1/31/2023 6:23 AM, hubert depesz lubaczewski wrote:
> Not sure why:
>
> 2. you ask me that off list
In a lot of email clients, it is very easy to accidentally reply to the 
author instead of the list without realizing it.

Hope that helps,
Brad.
-- 
Quote Signature I talk with clients, find out where their pain points 
are, and solve those.
On-call IT Management for small companies and non-profits.
SCP, Inc.
bwhite@inebraska.com
402-601-7990


Quote of the Day
    There is a huge difference between fathering a child and being a 
father.
    One produces a child. The other produces an adult.
     -- John Eldredge

^ permalink  raw  reply  [nested|flat] 17+ messages in thread

* Re: Best Open Source OS for Postgresql
  2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
@ 2023-02-01 16:05 ` Jeffrey Walton <noloader@gmail.com>
  2 siblings, 0 replies; 17+ messages in thread

From: Jeffrey Walton @ 2023-02-01 16:05 UTC (permalink / raw)
  To: Giovanni Biscontini <biscontini.g@es2000.it>; +Cc: pgsql-general@lists.postgresql.org

On Tue, Jan 31, 2023 at 3:03 AM Giovanni Biscontini <biscontini.g@es2000.it>
wrote:

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

Let me throw my choice into the mix... Fedora Server.

The benefits of Fedora Server is modern software. Every six months, you get
the latest release of nearly all packages.

The downside is, you lose API/ABI compatibility. Fedora Server is always
moving forward with the latest packages, including past ABI/API breaks.
Another downside is, you run dnf-system-upgrade (
https://docs.fedoraproject.org/en-US/quick-docs/dnf-system-upgrade/) every
six months. It is like Ubuntu's do-release-upgrade.

The real upside to modern software is, you get all the bug fixes, including
latent bugs that should have CVE's associated with them but were
misclassified. For a discussion, see Greg KH's talk at
https://thenewstack.io/design-system-can-update-greg-kroah-hartman-linux-security/
.

Jeff

^ permalink  raw  reply  [nested|flat] 17+ messages in thread


end of thread, other threads:[~2023-02-01 18:53 UTC | newest]

Thread overview: 17+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-01-31 08:02 Best Open Source OS for Postgresql Giovanni Biscontini <biscontini.g@es2000.it>
2023-01-31 11:59 ` Surya Widyanto <ayrus02@gmail.com>
2023-01-31 12:06 ` hubert depesz lubaczewski <depesz@depesz.com>
2023-01-31 12:23   ` hubert depesz lubaczewski <depesz@depesz.com>
2023-01-31 13:09     ` Marc Millas <marc.millas@mokadb.com>
2023-01-31 13:21       ` hubert depesz lubaczewski <depesz@depesz.com>
2023-01-31 16:38       ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-02-01 15:54         ` Marc Millas <marc.millas@mokadb.com>
2023-02-01 16:25           ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-02-01 17:22             ` Bob Jolliffe <bobjolliffe@gmail.com>
2023-02-01 18:53               ` Adrian Klaver <adrian.klaver@aklaver.com>
2023-02-01 06:19       ` Tony Shelver <tshelver@gmail.com>
2023-02-01 06:45         ` Brent Wood <Brent.Wood@niwa.co.nz>
2023-02-01 15:21           ` Wim Bertels <wim.bertels@ucll.be>
2023-02-01 15:39         ` Marc Millas <marc.millas@mokadb.com>
2023-02-01 06:39     ` Brad White <b55white@gmail.com>
2023-02-01 16:05 ` Jeffrey Walton <noloader@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox