In order to install the postgres 15 client on Amazon Linux 2023, you can do the following.
First check the available packages
sudo dnf search postgres
You will see in the output, a list of postgres packages, that are available to install.. In order to install the client tools, install the postgresql15 package
sudo dnf install postgresql15
Once the package is installed you have access to psql, pg_dump etc.