Re: Best Open Source OS for Postgresql

2023-02-01 Thread Adrian Klaver
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

Re: Best Open Source OS for Postgresql

2023-02-01 Thread Bob Jolliffe
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

Re: Best Open Source OS for Postgresql

2023-02-01 Thread Adrian Klaver
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 wi

Re: Best Open Source OS for Postgresql

2023-02-01 Thread Jeffrey Walton
On Tue, Jan 31, 2023 at 3:03 AM Giovanni Biscontini 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 sha

Re: Best Open Source OS for Postgresql

2023-02-01 Thread Marc Millas
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

Re: Best Open Source OS for Postgresql

2023-02-01 Thread Marc Millas
Hello, What about postgis : 3.0, 3.3, 3.4 ?? Le mer. 1 févr. 2023 à 07:20, Tony Shelver a écrit : > > Copied to the list > On Wed, 1 Feb 2023 at 08:18, Tony Shelver wrote: > >> >> >> On Wed, 1 Feb 2023 at 08:04, Tony Shelver wrote: >> >>> >>> On Tue, 31 Jan 2023 at 15:10, Marc Millas >>> wrot

Re: Best Open Source OS for Postgresql

2023-02-01 Thread Wim Bertels
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 f

Re: Best Open Source OS for Postgresql

2023-02-01 Thread Brent Wood
ician, Fisheries NIWA DDI: +64 (4) 3860529 From: Tony Shelver Sent: Wednesday, February 1, 2023 19:19 To: pgsql-general Subject: Re: Best Open Source OS for Postgresql Copied to the list On Wed, 1 Feb 2023 at 08:18, Tony Shelver mailto:tshel...@gmail.com>>

Re: Best Open Source OS for Postgresql

2023-01-31 Thread Brad White
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 whe

Re: Best Open Source OS for Postgresql

2023-01-31 Thread Tony Shelver
Copied to the list On Wed, 1 Feb 2023 at 08:18, Tony Shelver wrote: > > > On Wed, 1 Feb 2023 at 08:04, Tony Shelver wrote: > >> >> On Tue, 31 Jan 2023 at 15:10, Marc Millas wrote: >> >>> Sorry for inappropriate "reply". >>> >>> if you do check the debian postgis repo, you ll find that its NOT >

Re: Best Open Source OS for Postgresql

2023-01-31 Thread Adrian Klaver
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/do

Re: Best Open Source OS for Postgresql

2023-01-31 Thread hubert depesz lubaczewski
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. > (yo

Re: Best Open Source OS for Postgresql

2023-01-31 Thread Marc Millas
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 bein

Re: Best Open Source OS for Postgresql

2023-01-31 Thread hubert depesz lubaczewski
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

Re: Best Open Source OS for Postgresql

2023-01-31 Thread hubert depesz lubaczewski
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 pac

Re: Best Open Source OS for Postgresql

2023-01-31 Thread Surya Widyanto
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

Best Open Source OS for Postgresql

2023-01-31 Thread Giovanni Biscontini
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 ad