Foreman Postgres 15 support

We are a Debian shop, and are using Foreman/Katello on EL9 to manage our Debian machines.
Since Foreman is the single outlier, we were wondering if it is possible to use an external PostgreSLQ 15 database with Foreman 3.10+

We know that EL supports Postgres 13 for a long time, but we wanted to keep outliers to a minimum, so installing Postgres on Debian 12 would get us Postgres 15 (or even 17 from mid 2025). Is that possible or supported in any way? Would the foreman-installer bail, if it finds an unsupported Postgres version?