Re: Best Open Source OS for Postgresql

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(at)gmail(dot)com>
Sent: Wednesday, February 1, 2023 19:19
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Best Open Source OS for Postgresql

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

On Wed, 1 Feb 2023 at 08:04, Tony Shelver <tshelver(at)gmail(dot)com<mailto:tshelver(at)gmail(dot)com>> wrote:

On Tue, 31 Jan 2023 at 15:10, Marc Millas <marc(dot)millas(at)mokadb(dot)com<mailto:marc(dot)millas(at)mokadb(dot)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<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Flaunchpad.net%2F~ubuntugis%2F%2Barchive%2Fubuntu%2Fppa%2F%2Bindex%3Fbatch%3D75%26memo%3D75%26start%3D75&data=05%7C01%7CBrent.Wood%40niwa.co.nz%7C27575ec68b7b481e029508db041c64f3%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C638108292256807488%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Chlgpp%2F1nYCuOzzQ0eDEqVzAbQGUjLSntqC51mwHaYM%3D&reserved=0>
Got this link from https://wiki.ubuntu.com/UbuntuGIS<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwiki.ubuntu.com%2FUbuntuGIS&data=05%7C01%7CBrent.Wood%40niwa.co.nz%7C27575ec68b7b481e029508db041c64f3%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C638108292256807488%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=zb8zbuQnogekZSDCRnWyGiyo6Yxbznqv6CbDSTp214g%3D&reserved=0> via https://postgis.net/install/<https://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fpostgis.net%2Finstall%2F&data=05%7C01%7CBrent.Wood%40niwa.co.nz%7C27575ec68b7b481e029508db041c64f3%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C638108292256807488%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=YBbshMrRUhA7EVaW28g4E%2BvZ0PNGafVVivvUC7FzKyM%3D&reserved=0>
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%2Fwiki.debian.org%2FDebianGis&data=05%7C01%7CBrent.Wood%40niwa.co.nz%7C27575ec68b7b481e029508db041c64f3%7C41caed736a0c468aba499ff6aafd1c77%7C0%7C0%7C638108292256807488%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=Ufd57MDATI%2F0fqTiJDGNigV%2BKbHeKm3vrRxnnkTC20Y%3D&reserved=0>

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