Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pN8tW-00021E-W7 for pgsql-general@arkaria.postgresql.org; Wed, 01 Feb 2023 08:55:07 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pN8tV-00029C-SJ for pgsql-general@arkaria.postgresql.org; Wed, 01 Feb 2023 08:55:05 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pN6sS-0004d8-LU for pgsql-general@lists.postgresql.org; Wed, 01 Feb 2023 06:45:53 +0000 Received: from mail-sgaapc01on2126.outbound.protection.outlook.com ([40.107.215.126] helo=APC01-SG2-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pN6sO-0007Uk-VR for pgsql-general@lists.postgresql.org; Wed, 01 Feb 2023 06:45:51 +0000 ARC-Seal: i=2; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=pass; b=oShzClkfKJs4p4uOBit5SVu7GJYMKNzrsfLucTFYAINdmYjL34haJT1BV0bQPIIPXXOEeOO7OwgL/KaO6BBSz7b+FrW7u1pW69HMAFmU1CP5yoZOLLApq4drH2Dmitu+GU1T4T4yDvCH3AjjSJXdhcUNAYHnpuxQswrShpk3psZX3UUwpRTw+F3nvXqpk8wr25rV9j7JjbqfALwRiAwTdN2fQi6pXz9wg0BoYQVtwaKbUOWGCsagOBWXKrF/qpryAhq0lwHqLXt79u9PDxU2KZVEEq8p/JvXJtLavKjJgO1vq+DPhV249tNvsWk1p1Y/ZI7POlp0NdkAPNxMkyGSNw== ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=VWJaX4zRaVCUo1yFPj6Znt/KPiQ++xypEXn6svOD0C4=; b=arjUehBz+ipVl/85pj4/Ky7DBGZ/COHqXrdn3P/oGAI3DSspX8enaIqxtbLKz6gJdoqcLbbE2MJDkrbEBBE0MGL11fecXZzKeUYIhhMEPTPYlvFiu6PQh+TIEIEtMseKEsjNdTWNEpDlU8dFxNp7QhtA+ZuY6fwhTGQ+pYVYMl3R6ektLaHKT+S9T3VeonYSJaEIlQmt4oMwez6TcM2Zik2tqNQarq1aW+0BAePUi+Q3j5QQ1HSZeLleaHZvJ9AZpAJX74s2CBBKWT5P00gvxV5E9I6V2HsOlj1ft4YnkuLDXI6PnPDRvADcOnbtOk5Ji6Tuui11QxedRTNgejfAtg== ARC-Authentication-Results: i=2; mx.microsoft.com 1; spf=pass (sender ip is 104.47.26.110) smtp.rcpttodomain=lists.postgresql.org smtp.mailfrom=niwa.co.nz; dmarc=pass (p=none sp=none pct=100) action=none header.from=niwa.co.nz; dkim=pass (signature was verified) header.d=niwa.onmicrosoft.com; arc=pass (0 oda=1 ltdi=1 spf=[1,1,smtp.mailfrom=niwa.co.nz] dkim=[1,1,header.d=niwa.co.nz] dmarc=[1,1,header.from=niwa.co.nz]) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=niwa.onmicrosoft.com; s=selector1-niwa-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=VWJaX4zRaVCUo1yFPj6Znt/KPiQ++xypEXn6svOD0C4=; b=DBXZ9cwDubDSp71xnb0zt66cXHAe9f01wkU81GMfqg53IuIafwex4JVMZKwcgNycaKBRFXB4i5MbtBDUT18p5EN4R9t+ycyY99yVKnkHrghRc/2SwUuSNRBJcrs6Cd8tWXecW9CD+H58yuqM5bxcGGo2ud6nKuWg+ZSQAH9lCKw= Received: from SY6PR01CA0062.ausprd01.prod.outlook.com (2603:10c6:10:ea::13) by SYBPR01MB7852.ausprd01.prod.outlook.com (2603:10c6:10:1b3::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6064.22; Wed, 1 Feb 2023 06:45:41 +0000 Received: from SY4AUS01FT021.eop-AUS01.prod.protection.outlook.com (2603:10c6:10:ea:cafe::6) by SY6PR01CA0062.outlook.office365.com (2603:10c6:10:ea::13) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6043.38 via Frontend Transport; Wed, 1 Feb 2023 06:45:41 +0000 X-MS-Exchange-Authentication-Results: spf=pass (sender IP is 104.47.26.110) smtp.mailfrom=niwa.co.nz; dkim=pass (signature was verified) header.d=niwa.onmicrosoft.com;dmarc=pass action=none header.from=niwa.co.nz; Received-SPF: Pass (protection.outlook.com: domain of niwa.co.nz designates 104.47.26.110 as permitted sender) receiver=protection.outlook.com; client-ip=104.47.26.110; helo=APC01-SG2-obe.outbound.protection.outlook.com; pr=C Received: from wellmail.niwa.co.nz (202.36.29.34) by SY4AUS01FT021.mail.protection.outlook.com (10.114.156.176) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6064.22 via Frontend Transport; Wed, 1 Feb 2023 06:45:41 +0000 Received: from APC01-SG2-obe.outbound.protection.outlook.com (mail-sgaapc01lp2110.outbound.protection.outlook.com [104.47.26.110]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mail.protection.outlook.com", Issuer "DigiCert Cloud Services CA-1" (not verified)) by wellmail.niwa.co.nz (Postfix) with ESMTPS id 04B91605DEF for ; Wed, 1 Feb 2023 19:45:40 +1300 (NZDT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Vu07rwE8u8bKbg6nxi4zTbiAmhtrubkxOdKKB1mpd1NtqIDOUSdUCxoRyMFTbS2yQt8RO7dtpV4sujV2csTI3SlBgqZcMOiS/7DE6shSNqLPTs7ux/2tUEVuMWDCaVf5lpDzNBk0ylKP35idLcwDUR/hyd516BCPhnhYS+DqxpyliRTqmQMje8ThoNRwO/MzPiP//wLgiDa15juqU0hFrNKZr0nH7VAEtLhTXw6oXC4x9ngfpNn1lF+jHGbHuK0XQzpOZdoHuEYC4Tj7hX9/C/O5iB6VvHwgfl1NWKT7HRGlB/DFm92WuTp0E2MG9Z53pR+Jr8EhDL8yllbT0bHLvA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=VWJaX4zRaVCUo1yFPj6Znt/KPiQ++xypEXn6svOD0C4=; b=CvpG8Ayo8Icz+owE5a6dH6/XkT83WQu5SwVr0GPIFV5lGxBiUhXJwKrgZV9Qm8RSaF8wJVYXYAxDBBo8V4Xqs+1gYKcaf6dL5dnrIwH7kVqbhJ+o++k1/Khe2+cryEIAGmkJxNIczEdc2t7uoxNuQUEpKHZ7enj74S3FPrbFjYBCi/gpdExbxjmbA9WT/CPLWzvnx1l8VKMA0xyQB31kuZXmPJcHhsCgOW8hvL71KIqYv/piQ8jH4ugYJ6NCsW33KbWuc/YLYDr1I8zQyMw0OzMGem82+wcGTDHzSuQ6Riaz7O7Xagv4Hav1E5RbxgmmnRiM301qHV8ZF8kg3qc+CQ== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=niwa.co.nz; dmarc=pass action=none header.from=niwa.co.nz; dkim=pass header.d=niwa.co.nz; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=niwa.onmicrosoft.com; s=selector1-niwa-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=VWJaX4zRaVCUo1yFPj6Znt/KPiQ++xypEXn6svOD0C4=; b=DBXZ9cwDubDSp71xnb0zt66cXHAe9f01wkU81GMfqg53IuIafwex4JVMZKwcgNycaKBRFXB4i5MbtBDUT18p5EN4R9t+ycyY99yVKnkHrghRc/2SwUuSNRBJcrs6Cd8tWXecW9CD+H58yuqM5bxcGGo2ud6nKuWg+ZSQAH9lCKw= Received: from SY4PR01MB7076.ausprd01.prod.outlook.com (2603:10c6:10:145::5) by SYBPR01MB6175.ausprd01.prod.outlook.com (2603:10c6:10:ec::7) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6064.22; Wed, 1 Feb 2023 06:45:37 +0000 Received: from SY4PR01MB7076.ausprd01.prod.outlook.com ([fe80::5dfe:cb00:d469:7b43]) by SY4PR01MB7076.ausprd01.prod.outlook.com ([fe80::5dfe:cb00:d469:7b43%9]) with mapi id 15.20.6064.022; Wed, 1 Feb 2023 06:45:37 +0000 From: Brent Wood To: pgsql-general Subject: Re: Best Open Source OS for Postgresql Thread-Topic: Best Open Source OS for Postgresql Thread-Index: AQHZNUp9fIACHiPnzU2UCCCX6FT67664bjmAgAAE55+AAAzYAIABH/55gAAFuKo= Date: Wed, 1 Feb 2023 06:45:37 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: Authentication-Results-Original: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=niwa.co.nz; x-ms-traffictypediagnostic: SY4PR01MB7076:EE_|SYBPR01MB6175:EE_|SY4AUS01FT021:EE_|SYBPR01MB7852:EE_ X-MS-Office365-Filtering-Correlation-Id: 1e303abb-e07a-4f15-d9bf-08db041fefa0 x-niwa-seemail: Out X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam-Untrusted: BCL:0; X-Microsoft-Antispam-Message-Info-Original: 6/GQXuvCy0eP423GLPbdTx8BaIXkFQRkcKc7g0mQlnCFesnDAixGISErs+Ne9ZPvVEjJVcXNOCQVnNoyPg+1q+sSt3GGm1yS8DW0GKXtZmKSnyoXTCJylwqdAM2SK1dj0B96D6HmYtC6lESGeq9uBo56+6wlLofCdScsz2Xsy1yUErJGfkcktgotGWkPLMfJ1E23n6waeNAgdy2zwpTATVv/4WXuEhpBFoS0ckbK25RlJ+1UuOMdktFyW7QyKcLkHVfPrdW+5Dt57P2w+uf0EBYxdXBgY5wdAucMvcn7YjP//dZr7EqzitirmIAbfjUOZL5NMJv1+CeRnCVYKiL0BBiaEuYCXUdpfWVckmlELuSjp5RsbZMbyGADmELUmMSwHNSeUQUfDpSxKEijid8cVK9ojeqdYCyABN+DIDnI4I/+Z7etb+wbmpjdGKrVNN0uv7pFtQJb8wT4ma+Jo/6ua9lwzHXkCLSktmZ+zM5/7xHjcZkxyX87vVD1uchlkgvyg7O6riqJFkS3Xp7JV22RFFBDmtDZHLhGW9jXDABWUy5vHpx3tsyz0ZLdp3Tjwg9dXlONvAGPUmx3NE5FDowArcphpGzBgxlb7bKhBP11yLwWaFKq+CMBQpx1tiBA54XRHMmEpL358irZOOIRqfwgb1Lf2tBksWr11laDNiSDa52hU/E+c38T3Q5GThVPSF8sRMtG/mXiJKIoBRIpCV2hAoqpwxex+BwGSzD1eWGusxk= X-Forefront-Antispam-Report-Untrusted: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SY4PR01MB7076.ausprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230025)(4636009)(396003)(376002)(346002)(39860400002)(366004)(136003)(451199018)(1690799011)(166002)(38100700002)(122000001)(86362001)(55016003)(38070700005)(316002)(66946007)(41300700001)(76116006)(66446008)(66556008)(6916009)(66476007)(8676002)(186003)(64756008)(9686003)(53546011)(6506007)(26005)(45080400002)(966005)(478600001)(19627405001)(71200400001)(2906002)(7696005)(33656002)(8936002)(52536014)(5660300002)(83380400001);DIR:OUT;SFP:1102; Content-Type: multipart/alternative; boundary="_000_SY4PR01MB7076BA3B91A40E5A7B32C165A1D19SY4PR01MB7076ausp_" MIME-Version: 1.0 X-MS-Exchange-Transport-CrossTenantHeadersStamped: SYBPR01MB6175 X-EOPAttributedMessage: 0 X-MS-Exchange-SkipListedInternetSender: ip=[104.47.26.110];domain=APC01-SG2-obe.outbound.protection.outlook.com X-MS-Exchange-ExternalOriginalInternetSender: ip=[104.47.26.110];domain=APC01-SG2-obe.outbound.protection.outlook.com X-MS-Exchange-Transport-CrossTenantHeadersStripped: SY4AUS01FT021.eop-AUS01.prod.protection.outlook.com X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id-Prvs: ef742600-f1c9-47c2-a998-08db041fed0c X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: =?us-ascii?Q?QJxo8kd3jto/lez7U1qXXs9ASW2mrCYUPrCAJvKIKCKhgxmjDuKpVE6W3240?= =?us-ascii?Q?zH1maCS2ADgdWOT3b7XYvJ1tTXD62rvVkkQziXtcMwOeCPZJ1YmK6qmgko3g?= =?us-ascii?Q?hFDH9PGzLzlTU4rkTndwiUdAua5geeEX3bvWyG0XdQIn15phAJZ8Jd6TjFLw?= =?us-ascii?Q?wli4RpKYvo0vSevPc0TuN2mtBslguaX17glwYCVc57QX1eyXiw8KzPI7s4ju?= =?us-ascii?Q?MGMmtSIL3PYOwriBi34+p0E9zgF3VcTLy3v8+1NvcFEi8CohkGYtSt0UTLTO?= =?us-ascii?Q?BEFTnpwaMZtjEgBEkRSXCrW/MPhi4jzfqzRIaSrozZ0ljANN4PABODMfelAx?= =?us-ascii?Q?wVklt9qGiUlYfkI5UVPHKfMAKSAVyx2/EqwKHMtwiX2Y3W8mtWu2jVQGQ93R?= =?us-ascii?Q?ZcYLGFeBabqCe4Xkj87PQwGTz6K579V3m41Gi1B9v1esl3mTcJOlFDP/NWNI?= =?us-ascii?Q?X95ErfchdvojUH59BDG8KBsSpF2Bs+8Kz05fPs3uXkqEkm+nV/6m31Eff9DV?= =?us-ascii?Q?WSPg0m+K1ECIxxD/Hn84oOMJz8mU+sVtdNjtsgcXZylRsuEPP5QALY1JKR/z?= =?us-ascii?Q?uqDDY1T9eUtC99JP7z0awo/0WZ9wIgqIPejmOB977j6hlejN6fAh6p+GkQ0x?= =?us-ascii?Q?90nCDeM9xIC0+bnAOpQroQHxnapjR0sWkH4IqUOIabKpx7d4M06wcpWzNvnL?= =?us-ascii?Q?OvhuQkBbHDQk31Wovy8Q7k1rYxRwa57zYByDkpIw5WBrEeQhDGxNX2EKqvUo?= =?us-ascii?Q?1o97hKSztGY7F4Vw15eLSg439dtycZKuu/eed+wW8GxNQ5DBscUHxq1e5yv7?= =?us-ascii?Q?JrByFcodSBggoM9PWA5QhA1Kj3cQiyzMJ+98OTV0tSmZUKJhRvFxRbMdMOCh?= =?us-ascii?Q?UTwMx/nu/F8iXl3Qc1WAtOS2xGe1LgyD2XOIFGJ69dys7yPtOr/T1l5S569a?= =?us-ascii?Q?ScZOfT+Ulb0ZCTtgTSoRsqTWbOneX9uUcF0yIOV7xHq3EvvF/OY5bfPwa5KH?= =?us-ascii?Q?xO2DRrrvRexcZu31XsbbiQ4Qli14RfFTEoq7cioDzXgFvXK+SJNHtz9vn/Ei?= =?us-ascii?Q?/F0CbVkH6s32HpPqovc28bCh8SJYAg=3D=3D?= X-Forefront-Antispam-Report: CIP:202.36.29.34;CTRY:SG;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:APC01-SG2-obe.outbound.protection.outlook.com;PTR:mail-sgaapc01lp2110.outbound.protection.outlook.com;CAT:NONE;SFS:(13230025)(4636009)(396003)(376002)(346002)(39860400002)(136003)(451199018)(7200799011)(1690799011)(36840700001)(40470700004)(46966006)(166002)(86362001)(55016003)(40480700001)(40460700003)(82310400005)(316002)(82740400003)(336012)(47076005)(41300700001)(70586007)(70206006)(6916009)(8676002)(186003)(9686003)(53546011)(6506007)(26005)(45080400002)(966005)(478600001)(8400799011)(19627405001)(7636003)(2906002)(32850700003)(7696005)(156005)(36860700001)(33656002)(8936002)(52536014)(5660300002)(83380400001);DIR:OUT;SFP:1102; X-OriginatorOrg: niwa.co.nz X-MS-Exchange-CrossTenant-OriginalArrivalTime: 01 Feb 2023 06:45:41.2288 (UTC) X-MS-Exchange-CrossTenant-Network-Message-Id: 1e303abb-e07a-4f15-d9bf-08db041fefa0 X-MS-Exchange-CrossTenant-Id: 41caed73-6a0c-468a-ba49-9ff6aafd1c77 X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=41caed73-6a0c-468a-ba49-9ff6aafd1c77;Ip=[202.36.29.34];Helo=[wellmail.niwa.co.nz] X-MS-Exchange-CrossTenant-AuthSource: SY4AUS01FT021.eop-AUS01.prod.protection.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Anonymous X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: SYBPR01MB7852 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SY4PR01MB7076BA3B91A40E5A7B32C165A1D19SY4PR01MB7076ausp_ Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable 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 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 > 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 possible = to choose a postgis version. its possible for postgis 2.4 and 2.5, then ALL 3.x versions are inaccessibl= e 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 unabl= e to install the requested postgres/postgis version on debian. when I did ask the team, the reply was: we cannot package for all cross pos= sibilities (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 sourc= e? 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=3D= 75&memo=3D75&start=3D75 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.d= ebian.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 [https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] 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 Twitte= r Instagram To ensure compliance with legal requirements and to maintain cyber security= standards, NIWA's IT systems are subject to ongoing monitoring, activity l= ogging and auditing. This monitoring and auditing service may be provided b= y third parties. Such third parties can access information transmitted to, = processed by and stored on NIWA's IT systems --_000_SY4PR01MB7076BA3B91A40E5A7B32C165A1D19SY4PR01MB7076ausp_ Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
I would suggest any major Ubuntu based distro, I ha= ve 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.



Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529

From: Tony Shelver <tshe= lver@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 S= helver <tshelver@gmail.com>= wrote:


On Wed, 1 Feb 2023 at 08:04, Tony S= helver <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 poss= ible to choose a postgis version.
its possible for postgis 2.4 and 2.5, then ALL 3.x versions are inacce= ssible 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 cros= s 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=3D75&am= p;memo=3D75&start=3D75
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 lice= nsing has led us to support it only for one specific application that is em= bedded in Centos that we are trying to end-of-life ASAP.  At least Ubu= ntu server has a 5 year support window, and Ubuntu has now announced a limited 'free' Pro option for smaller businesse= s that provides a 10 year window.


Regards


Brent Wood
Principal Technician - GIS and Spatial Data Managem= ent
Programme Leader - Environmental Information Delive= ry
+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 requirement= s and to maintain cyber security standards, NIWA's IT systems are subject t= o ongoing monitoring, activity logging and auditing. This monitoring and au= diting service may be provided by third parties. Such third parties can access information transmitted to, process= ed by and stored on NIWA's IT systems --_000_SY4PR01MB7076BA3B91A40E5A7B32C165A1D19SY4PR01MB7076ausp_--