Hello there 
I´m wondering which PostgreSQL version might be the latest, AWX supports.
Could there be any limitations?
We´d like to upgrade our AWX DB Hosts, if possible to PostgreSQL version 15.
Red Hat specifies version 13 for their product.
Is anyone already successfully using a more recent PostgreSQL version (15) for AWX?
Thank you very much!
You can use an external database. I do that using cloud native postgres and unmanaged and it works
I am using postgres 15.3
If you are using an external DB we don’t specify a requirement specifically other than >12.
If you do use a later version, please let us know if you run into any issues!
There are two PRs opened to make 15 the default version for both AWX and operator if you can help test these it would be fantastic!
https://github.com/ansible/awx/pull/14230
https://github.com/ansible/awx-operator/pull/1486
We are currently setting up a DB Cluster with PostgreSQL 15. We will attempt to make the switch from DB verion 12 to 15 soon.
Thank you for the hint regarding those pull requests.
I will try to contribute and pass information on our progress/occurring problems.
I am wondering if AWX uses prepared statements when contacting the DB?
One of our DB admins told me, the DB cluster (connection pool) would not be able to enfold its full performance potential if that would be the case, since the connection mode “transaction” would not work if the application uses prepared statements.
At this time we do not support clustered databases, please let us know how that works for you!
-AWX Team