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 1r1MTS-00AiXA-L4 for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Nov 2023 08:02:43 +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 1r1MTR-002DHx-6e for pgsql-bugs@arkaria.postgresql.org; Fri, 10 Nov 2023 08:02:41 +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 1r1MTQ-002DHg-HU for pgsql-bugs@lists.postgresql.org; Fri, 10 Nov 2023 08:02:40 +0000 Received: from pv50p00im-ztbu10011701.me.com ([17.58.6.53]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1r1MTM-005hNL-By for pgsql-bugs@lists.postgresql.org; Fri, 10 Nov 2023 08:02:39 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=vonng.com; s=sig1; t=1699603353; bh=eGUbefV0vUfLM+dxBVjDCDz/4In3MC5qpi9Uj5QJ8hw=; h=From:Content-Type:Mime-Version:Subject:Message-Id:Date:To; b=R2hhPBFzA1ZDEetlG4f8a2xHRs70V2MePNBb/HNQrUTTsbF05/3IF7lKDbIWJveEB Q8U8E4V/HCcor7WX4C7i9fePGdFfMcbetwHn0YXSH1Gx4cwAXQZR0KcgsfcrCFTkJH quKT8OmrGYo/LD1sZMbnZsp73s2RUDeBAtmvcw2wkshw3yMY9Qkt3Cq3+5Ekk7z0lo ps0j7E9/Bx608BqY1Q00f2EXTGKTZdjsgE+2D4BoNMj2tfhHjr1KgIklnGD6Xaygz0 QY0A7LV9Wn0HtLc8RMeyMTBnxyVjyddwxcn/7+VcukwZx7+EuhXsM+FqpM7A7fzmdm Lf2rLo7VpykQA== Received: from smtpclient.apple (pv50p00im-dlb-asmtp-mailmevip.me.com [17.56.9.10]) by pv50p00im-ztbu10011701.me.com (Postfix) with ESMTPSA id D4564740129 for ; Fri, 10 Nov 2023 08:02:32 +0000 (UTC) From: rh@vonng.com Content-Type: multipart/alternative; boundary="Apple-Mail=_E7D2406F-7CCB-4D97-841C-23FADAA08B44" Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3731.700.6\)) Subject: Issues Encountered with PostgreSQL 16.1 RPM on EL8/EL9 Message-Id: Date: Fri, 10 Nov 2023 16:02:14 +0800 To: pgsql-bugs X-Mailer: Apple Mail (2.3731.700.6) X-Proofpoint-GUID: zcJeiKeeVcWe4NQNnbe222E_51gVR10Y X-Proofpoint-ORIG-GUID: zcJeiKeeVcWe4NQNnbe222E_51gVR10Y X-Proofpoint-Virus-Version: =?UTF-8?Q?vendor=3Dfsecure_engine=3D1.1.170-22c6f66c430a71ce266a39bfe25bc?= =?UTF-8?Q?2903e8d5c8f:6.0.517,18.0.572,17.11.64.514.0000000_definitions?= =?UTF-8?Q?=3D2022-06-21=5F01:2022-06-21=5F01,2020-02-14=5F11,2022-02-23?= =?UTF-8?Q?=5F01_signatures=3D0?= X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 mlxlogscore=999 bulkscore=0 suspectscore=0 clxscore=1030 adultscore=0 malwarescore=0 mlxscore=0 phishscore=0 spamscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2308100000 definitions=main-2311100066 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail=_E7D2406F-7CCB-4D97-841C-23FADAA08B44 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Dear PGSQL-Bugs Team and PGDG maintainers, I hope this message finds you well. I am writing to share our excitement = about the recent release of PostgreSQL 16.1.=20 However, during our installation trials, we encountered a few issues = that we hope can be addressed. Missing `plpython3` Package: We noticed that the plpython3 package is = missing in the EL8 / EL9 repositories=20 - https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8-x86_64/=20= - https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-9-x86_64/ This omission leads to RPM package conflicts when trying to install with = `yum install postgresql16*`.=20 This issue is not limited to the x86_64 architecture and has caused some = of our integrated workflows to break. Besides, here are some additional observations and issues that may be = helpful to increase the consistency of the PGDG repositories: - The EL9 repository lacks the pgxnclient package comparing to the = EL8/EL7 repo. - The RPM for pg_repack_16 remains unavailable, although it is present = in the APT repository. - For PostGIS (PG15), the latest version available on EL 8/9 is 3.4, = while on EL7, it is still 3.3. - patroni 3.2.0 is available on PGDG YUM REPO, but the APT repo is still = using the 3.1.2 - When trying to download patroni with repotrack , you'll get patroni = 3.0.4 and the latest version. Which is quite wierd. Concern Regarding Citus and Hydra Extensions: We also wish to address a potential issue with the new columnar storage = extension, `Hydra`, which is forked from Citus columnar.=20 There are potential RPM conflicts between these two extensions (through = there's no official hydra RPM yet).=20 It might be beneficial to consider splitting the Citus RPM into two = parts: the main body and Columnar,=20 offering users the choice between the default Columnar or Hydra's = Columnar. We greatly appreciate the work and dedication of the PGDG maintainers = and look forward to a resolution to these issues. Thank you for your attention to these matters. Best regards, Ruohang Feng (@Vonng) --Apple-Mail=_E7D2406F-7CCB-4D97-841C-23FADAA08B44 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii
Dear PGSQL-Bugs Team and PGDG maintainers,

I = hope this message finds you well. I am writing to share our excitement = about the recent release of PostgreSQL 16.1. 
However, during our installation trials, we encountered a few =
issues that we hope can be addressed.

Missing `plpython3` = Package: We noticed that the plpython3 package is missing in the EL8 / = EL9 repositories

- = https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8-x86_64/ =
- = https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-9-x86_64/
=
This omission leads to RPM package conflicts when trying to install = with `yum install postgresql16*`.
This issue is not limited to the = x86_64 architecture and has caused some of our integrated workflows to = break.

Besides, here are some additional observations and issues = that may be helpful to increase the consistency of the PGDG = repositories:

- The EL9 repository lacks the pgxnclient package = comparing to the EL8/EL7 repo.
- The RPM for pg_repack_16 remains = unavailable, although it is present in the APT repository.
- For = PostGIS (PG15), the latest version available on EL 8/9 is 3.4, while on = EL7, it is still 3.3.
- patroni 3.2.0 is available on PGDG YUM REPO, = but the APT repo is still using the 3.1.2
- When trying to download = patroni with repotrack , you'll get patroni 3.0.4 and the latest = version. Which is quite wierd.

Concern Regarding Citus and Hydra = Extensions:

We also wish to address a potential issue with the = new columnar storage extension, `Hydra`, which is forked from Citus = columnar.
There are potential RPM conflicts between these two = extensions (through there's no official hydra RPM yet).
It might be = beneficial to consider splitting the Citus RPM into two parts: the main = body and Columnar,
offering users the choice between the default = Columnar or Hydra's Columnar.

We greatly appreciate the work and = dedication of the PGDG maintainers and look forward to a resolution to = these issues.
Thank you for your attention to these = matters.


Best regards,

Ruohang Feng = (@Vonng)

= --Apple-Mail=_E7D2406F-7CCB-4D97-841C-23FADAA08B44--