AWX -> max. PostgreSQL version? (15)

[Tian Muc]

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! :)

[Wei-Yen Tan]

You can use an external database. I do that using cloud native postgres and unmanaged and it works 

Sent from Outlook for iOS

---

From: awx-p...@googlegroups.com <awx-p...@googlegroups.com> on behalf of Tian Muc <tianm...@gmail.com>
Sent: Friday, August 4, 2023 11:03:40 PM
To: AWX Project <awx-p...@googlegroups.com>
Subject: [awx-project] AWX -> max. PostgreSQL version? (15)

 

--
You received this message because you are subscribed to the Google Groups "AWX Project" group.
To unsubscribe from this group and stop receiving emails from it, send an email to awx-project...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/awx-project/d2633a79-a267-44c4-ac7f-91428a23dc27n%40googlegroups.com.

[Wei-Yen Tan]

I am using postgres 15.3 

Sent from Outlook for iOS

---

From: Wei-Yen Tan <weiye...@gmail.com>
Sent: Friday, August 4, 2023 11:05:21 PM
To: awx-p...@googlegroups.com <awx-p...@googlegroups.com>
Subject: Re: [awx-project] AWX -> max. PostgreSQL version? (15)

 

[AWX Project]

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

- The AWX Team

[Tian Muc]

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. :)

[Tian Muc]

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.

[AWX Project]

At this time we do not support clustered databases, please let us know how that works for you!

-AWX Team