Postgres Pro
Downloads
Home   >   mailing lists

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

From Brent Wood
Subject Re: Best Open Source OS for Postgresql
Date
Msg-id SY4PR01MB7076BA3B91A40E5A7B32C165A1D19@SY4PR01MB7076.ausprd01.prod.outlook.com
Whole thread Raw
In response to Re: Best Open Source OS for Postgresql  (Tony Shelver <tshelver@gmail.com>)
Responses Re: Best Open Source OS for Postgresql  (Wim Bertels <wim.bertels@ucll.be>)
List pgsql-general
Tree view
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> 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
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


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 Facebook LinkedIn Twitter Instagram
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

pgsql-general by date:

Previous
From: Brad White
Date:
Subject: Re: Best Open Source OS for Postgresql
Next
From: qihua wu
Date:
Subject: invisible commit question for sync replication