[Feature Request] - Postgresql18Client

[flarocca-topnetwork]

Is your feature request related to a problem? Please describe.
Yes. Currently, Amazon Linux 2023 (AL2023) does not provide the postgresql18-client package in its official repositories. As we upgrade our database workloads to PostgreSQL 18, we lack a native, officially supported client CLI (psql) and development libraries on AL2023 to interact with these databases. Running older client versions (e.g., PostgreSQL 15/16 clients) is suboptimal as they lack support for the latest PostgreSQL 18 syntax, features, and system catalog changes.

Describe the solution you'd like
I would like AWS to package and distribute the PostgreSQL 18 client and its development libraries (e.g., postgresql18, postgresql18-devel) directly via the default AL2023 dnf repositories. This would allow us to install the updated client seamlessly using:

sudo dnf install postgresql18

[sethaar]

This already exists.

Available Packages
Name : postgresql18
Version : 18.4
Release : 1.amzn2023.0.1
Architecture : aarch64
Size : 2.0 M
Source : postgresql18-18.4-1.amzn2023.0.1.src.rpm
Repository : amazonlinux
Summary : PostgreSQL client programs
URL : http://www.postgresql.org/
License : PostgreSQL
Description : PostgreSQL is an advanced Object-Relational database management system (DBMS).
: The base postgresql package contains the client programs that you'll need to
: access a PostgreSQL DBMS server, as well as HTML documentation for the whole
: system. These client programs can be located on the same machine as the
: PostgreSQL server, or on a remote machine that accesses a PostgreSQL server
: over a network connection. The PostgreSQL server can be found in the
: postgresql-server sub-package.