Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sF8gX-007N1f-Bz for pgsql-general@arkaria.postgresql.org; Thu, 06 Jun 2024 08:41:26 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1sF8gX-00GbgY-26 for pgsql-general@arkaria.postgresql.org; Thu, 06 Jun 2024 08:41:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1sF8gW-00GbgQ-LL for pgsql-general@lists.postgresql.org; Thu, 06 Jun 2024 08:41:24 +0000 Received: from mail-lj1-x234.google.com ([2a00:1450:4864:20::234]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sF8gP-000GW3-DC for pgsql-general@lists.postgresql.org; Thu, 06 Jun 2024 08:41:23 +0000 Received: by mail-lj1-x234.google.com with SMTP id 38308e7fff4ca-2e73359b900so7546411fa.2 for ; Thu, 06 Jun 2024 01:41:17 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1717663276; x=1718268076; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id:from:to:cc :subject:date:message-id:reply-to; bh=5XE9vYTsOVVhT+MsGHsvPjWCeLgljXPgy3gCfTfZJy8=; b=ZtzBXagf0rjLECe7cfV48wC0ORi8e8L0mTFdyOgZPzM96ZamKeU6skz1hghOVBgysJ Qqh+C2LcT4bBIZDKysSSOB/fktjTHB+XMOSSs/ychJr8AqcaNy6dEz6lWfsgr+HNUezb IPil1meOlQjphkmx56WF5EkJPImf+7wFiluZsp3L2IMZDaZpLXeubd7PQIWGsvNzq/+Z xZGXHUwp+FW0uhl7YCmK48Dt3DTcOZ+aTG7tvadYOBSXRxyY8Ik10kDpzbFXqpNtIvb4 iZZC4QblLoZKHZOmc39DD3RpR087bF0E1VnEmOkF2Up+7ro6UWqdgKhqg+jhUCr8wHa5 eDWQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1717663276; x=1718268076; h=mime-version:user-agent:content-transfer-encoding:autocrypt :references:in-reply-to:date:to:from:subject:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=5XE9vYTsOVVhT+MsGHsvPjWCeLgljXPgy3gCfTfZJy8=; b=Zg2DuUhBfrkdCEF7vzHkoe5sDzBAyLutryi88LhtHIJdHiLrwh1rKn5Nzmn7lvWmhO i/AE1xj28cK2xihdkNGh1SGCX0IWFs2RjRW5gcc5yPIJjfDAT7TGpWpcldqtUS3w1bNm SZDLND2c6/xF3zBIeuXWiJ5qZDYJ5zq7vZIom/+2adXxV37PjB0J55uliPwnQUXEnKyN 4X1A5Vo+oZI8obtU7n1XmgYYvmzpqAIBJ3Bz+wjt7FfOZKTUd/5DrRukNSdJuCrPcJKa LIT2RxPByF7NIcwZJG6xVBfVs0buegWXEQZwnNb8JWcIvM37DbucLAtEum0jiVG3YxzE qZIw== X-Forwarded-Encrypted: i=1; AJvYcCXwuCKF2RAElcT0tXkWZEviDdiOqcXNgZqlbryUiRjJ3KxTzWAtPFsDymPF73sYdEbN7bt1Guj+gLc5K8N66v3RyRaj3+36jYNntQbW5PQoNLc2 X-Gm-Message-State: AOJu0YyaDp/FHHhWTRGRjFqM+jEbE4TjMFV5R6SQzzTeI5LBHgFxmESF mDF8aku4/C4rwkSDl07O8OkEEEmV8XWv3Y7VlSzpYh93Z+B79yqP8m31sdR1hVRPXsIC7OEUbR8 m X-Google-Smtp-Source: AGHT+IFwhyZ7T+e+k/u+TFIGmv6u6FNNDB2Hsh+7d4JFrrBrEJGbBhS41sFspde1IG4zFGpYWSzEJA== X-Received: by 2002:a2e:90d6:0:b0:2e8:4c3d:c9e6 with SMTP id 38308e7fff4ca-2eac7aad14fmr25752231fa.48.1717663276032; Thu, 06 Jun 2024 01:41:16 -0700 (PDT) Received: from localhost.localdomain ([88.116.133.170]) by smtp.gmail.com with ESMTPSA id 4fb4d7f45d1cf-57aae2341f8sm701749a12.86.2024.06.06.01.41.15 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 06 Jun 2024 01:41:15 -0700 (PDT) Message-ID: <436df37807c0c17a126f55ac86f2098c922642bc.camel@cybertec.at> Subject: Re: how to tell if a pg version supports a linux distribution From: Laurenz Albe To: bruno vieira da silva , pgsql-general@lists.postgresql.org Date: Thu, 06 Jun 2024 10:41:14 +0200 In-Reply-To: References: Autocrypt: addr=laurenz.albe@cybertec.at; prefer-encrypt=mutual; keydata=mQINBGGDwAQBEADgbWy5cKXQld3N2mF+DFyiNFbi2oBl2T+XgxpPF8wTRw2D/u4bBKXP0SYSE/lA86jIVNWWU0gf1KODIkVvgJm2w4vH2VBV1b7ddVViGl1Iu+9zaRnv9wulhnH42KefepXnoean6UT1EzLM0opF/Ik0j+40TxdRtobkBprkQUyHDXWlHc2ffPs3SipyFEP9AVLf7ejRC46CXWDnsqjOBSMEW8Z4HiK/8RrPZBsKLts8dJxKF4pygOdJb0CWk8k/X1jbcfdxo+zOLjOMvJcSJ2pFdJmQHU+JufB3rePziqQ2S9Ur6sccr9XnTC1GVBWN4Lf5VHq+vf+bFJjVwg+2hrySZnAVfcOrxoqFLErr7ug1zN2nM1kcpgA4VWn4gxlJtYNYYq+9WxX5dtvnNANlG3ZCrRKQzl8lxtzoF6Zo7LUhEqPaHDwn7Rvs+IdbOn41lF5UDTJGqmC4gS/bZydW2Fy3YWm4aSaN9fgFf8D+PVkrlKAZB7gBLz1TyHjbcRf85cYF+GKKrDld5SzMB/V60VX3oP/Eo8ikFpyWaqiz1f9X7MBot3/PjJkY+wDzp3nmb19QEcOBuQiSQ4xds2r0HewbuHTAR68u8jNNMGmpm2j4x+g09Jd/WQDjqlTBZ/jEltH41fYCCPWMfljXTOOXu2eLNGdfi7ETZogtwjM9oTtSPQARAQABtCdMYXVyZW56IEFsYmUgPGxhdXJlbnouYWxiZUBjeWJlcnRlYy5hdD6JAk4EEwEIADgWIQR0CqhbZGGABqoaSbdi8bhXA2EdmAUCYYPABAIbAwULCQgHAgYVCgkICwIEFgIDAQIeAQIXgAAKCRBi8bhXA2EdmM/6EADK232JCwmBzhlj8h7U9CjG6kx0JHP3uJGv+XfsHtHAlmY/RCwF1BHMEsRlk bT5UrLvJ2jb99bA9QARzhFaxzyn0F/BUKzuIjRGNs/n6d5dNUFA0kOt8sX+TacmC GEyjEBCrVCm4ranBiUyePn9NhHNWnaex7pJyqvMLLdwW9BEMJx0Fqo+DN8ukbXmYRsmhEtd3ue+x/luYmOmJnaGtzInaY5aOJYbW9XqoRIZkZvOCgbi1FfvNmoqWa+3oVxTOgw9RafjJDyW0lTHzKGjbGI5ofMU98l+/hKJFYJqWUF6VpFJY5YIcN/1lf4ZICMwDl+MPIVo/tpq8L10seJL28nLlvw3K+cI+TVW8IW/qL/LyVoDofI3USeOORuYmhpWRhik8JXX6xf3v6GrRilJIPWNFIJbxm1ZblQiQnOw3IOW7T+8nAmPin1HKqM3VrOrJQ2VtShsefNBibNAsr1oFaqcDBkn3yGG8i6CTW+FyO4PZ+/EwNxMVgktxbYdy5AT1/lpXr5tB+phhLIyVfiBvrWs5EThxYMQ/L8Y85c3GMsAy1l/x4h3jqySIYy3SCU9+jc5UVuNnXljbvkEzJ+NLWJ6C1rACFWrMszgPdh5tCrlRY9PpmYll4JbCgb8BtxEIUmR+xr50/ZElEK5iml7Q00KUekCcDt+36PsyGFTXBzNOrkCDQRhg8AEARAAzOZ2tLHlI4rrhG411h6cdCFjBZxuljaFCxFyHn3m6wbGLqwBUWC5k8UrRqjHMz88KcTSaNO7XGAmCqPdWd2SeflPZRnNTbjsVpw7mLdffsBm4JX7kki2Pvk5h0NtYeidXT1PSpc2ri4DutYXuT9uD8RAm1wUDCE5HQNUihT/WH6opt+hskHW21uHao0+y822tG0QQcGMqdQR5Vxdxj89wiEPdqW+HpU/oOZIhrf2E7prduAppxixjHy/o1rcnoznnJvc8D3+YgI9O0LrBMij89dM55pRGbLovTR1oGR3U74sX774+0xmSzeIKwZfiMUz7Atlvfk5SHOsRUFPN2Ux9kaXiiBibQpHFxt7b lDrT4wxdLJ/XCdbPPAyl+lZtOLsaHEEZvYNyTXwZc35dVf3R4/oz20HoG6s7ct8e1 AQygj43XAERzty9SkWgxs8+grp1PrGx6FHVSYRqBM8dS/ZR6yRVwOwJXPyaSSqfIF21DkE4j1y4n+ItSewPGoRp8K/yWCikt6qlkVkO2ASNIiX04fAbtzwVOaNn8ZMRNqyvLc1fED4sr49onE4cAIcBLjcC3KL+w9DUGRQCdziROj5H2Yl/sXGPdMciUHo/Uz2rggc+2th3bQiMhrHWSsBpUkDQp0yWewemstPpPgBL3h2fHKaX8B9oH5Qu/H1IgrOuX8AEQEAAYkCNgQYAQgAIBYhBHQKqFtkYYAGqhpJt2LxuFcDYR2YBQJhg8AEAhsMAAoJEGLxuFcDYR2YuPwQAMkpGtR80pQ1gVsONhdkqj0H2eU66efP/gO3CoyaoIcvrpKYj7C2HipVSmkt1gpByL0X4AMQ/vKuknUz3wd28Ba+G1dCfbVs/Xiusq+SmpUj5rTwmYqdSjWMuCo1R6oS5hdJMdUUJYGMT0QkVlm1KnW8jkmCTl9GzjDxOAsN9O6/6lPzaGFtk9XF+34Bry/N4HKiJkqpC4+UTd0AprPfzJ2jdT64e1F0+W88X8y1bTTgNrHwK4mDiLnlE4SKRuEm54lNhJz//ar86Or5BErzNpM6TL7lk44QS06hwsMrEdKIy8J/SYJPjfzR8tIUnKscclVpOgjKaBqC+0iFiVaRqAgfOlIEiezX6kMh5Q2FIUfqs46qWhhXjRrdKOEoStYAaikdLu5ZXr7vfb0ZaDh+ZwTQtbSMFolyOkecwI81MCdbMfT/1TqIGTOdAj5as9fAakk0jb2pXgUYQ8X1DVTR8ahSDVEaw9VTmWiSvTxvguVJ1Mb7gG4Gmh6aviDTJhfXtH4rPUNXhDLqrTH8JkJjyKROOMakIF68Hjse5vUfUxreBEOtb5r1Coa2Fe7ncJayaSE7ryrDbFqpZ 36UMAx4ulWMyqJajLNGY0DdG8qIsR5nxRhrnK/mrCidZ8F9/D3bWAl4rjtHlsztN59 +AnW5l0HsQcY9ntFL/zEBOaonjdJf Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.50.4 (3.50.4-1.fc39) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2024-06-05 at 16:24 -0400, bruno vieira da silva wrote: > Hello, if a pg version has been tested on the buildfarm but the pg yum > repository doesn't have packages for a linux distribution that means > that distribution isn't supported by pg? how can I find if linux > distributions for a pg version have=C2=A0regression tests executed agains= t. >=20 > e.g. : postgresql 16 doesn't have packages on yum for centos 7 but I > can find tests on the buildfarm for it. >=20 > https://buildfarm.postgresql.org/index.html PostgreSQL supports all Linux distributions. It doesn't particularly care about the distribution as long as all the required software is installed (https://www.postgresql.org/docs/current/install-requirements.htm= l). There are certainly other considerations. For example, if your Linux distribution uses musl as C library, which has dysfunctional collation support, then collations won't work in PostgreSQL either, since it uses that functionality by default. If you want to avoid surprises, it might be good to use widely-used distributions, but that doesn't mean that other distributions are not supported. Packaging is a completely different affair. PostgreSQL provides binary packages for the distributions that a packager cares about. If Devrim decides that he doesn't want to build packages for v16 for a crummy old CentOS release, that's his choice. Yours, Laurenz Albe