# AWX -\> max. PostgreSQL version? (15)

**URL:** <https://forum.ansible.com/t/awx-max-postgresql-version-15/38300>\
**Category:** AWX Project\
**Tags:** awx\
**Created:** [August 4, 2023, 11:03am UTC](https://forum.ansible.com/t/awx-max-postgresql-version-15/38300 "2023-08-04T11:03:40Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tian\_Muc](https://avatars.discourse-cdn.com/v4/letter/t/57b2e6/32.png) [@Tian\_Muc](https://forum.ansible.com/u/Tian_Muc)\
**Post date:** [August 4, 2023, 11:03am UTC](https://forum.ansible.com/t/awx-max-postgresql-version-15/38300/1 "2023-08-04T11:03:40Z")

</div>

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](https://access.redhat.com/documentation/de-de/red_hat_ansible_automation_platform/2.3/html/red_hat_ansible_automation_platform_planning_guide/platform-system-requirements#red_hat_ansible_automation_platform_system_requirements)version 13 for their product.

Is anyone already successfully using a more recent PostgreSQL version (15) for AWX?

Thank you very much! 🙂

---

<div class="post-metadata">

**Author:** ![Wei-Yen\_Tan](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/wei-yen_tan/32/4111_2.png) [@Wei-Yen\_Tan](https://forum.ansible.com/u/Wei-Yen_Tan)\
**Post date:** [August 4, 2023, 11:05am UTC](https://forum.ansible.com/t/awx-max-postgresql-version-15/38300/2 "2023-08-04T11:05:21Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Wei-Yen\_Tan](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/wei-yen_tan/32/4111_2.png) [@Wei-Yen\_Tan](https://forum.ansible.com/u/Wei-Yen_Tan)\
**Post date:** [August 4, 2023, 11:05am UTC](https://forum.ansible.com/t/awx-max-postgresql-version-15/38300/3 "2023-08-04T11:05:47Z")

</div>

I am using postgres 15.3

---

<div class="post-metadata">

**Author:** ![AWX\_Project](https://avatars.discourse-cdn.com/v4/letter/a/eada6e/32.png) [@AWX\_Project](https://forum.ansible.com/u/AWX_Project)\
**Post date:** [August 9, 2023, 6:40pm UTC](https://forum.ansible.com/t/awx-max-postgresql-version-15/38300/4 "2023-08-09T18:40:52Z")

</div>

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/pull/14230)  
[https://github.com/ansible/awx-operator/pull/1486](https://github.com/ansible/awx-operator/pull/1486)

- The AWX Team

---

<div class="post-metadata">

**Author:** ![Tian\_Muc](https://avatars.discourse-cdn.com/v4/letter/t/57b2e6/32.png) [@Tian\_Muc](https://forum.ansible.com/u/Tian_Muc)\
**Post date:** [August 16, 2023, 6:01pm UTC](https://forum.ansible.com/t/awx-max-postgresql-version-15/38300/5 "2023-08-16T18:01:15Z")

</div>

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. 🙂

---

<div class="post-metadata">

**Author:** ![Tian\_Muc](https://avatars.discourse-cdn.com/v4/letter/t/57b2e6/32.png) [@Tian\_Muc](https://forum.ansible.com/u/Tian_Muc)\
**Post date:** [August 16, 2023, 6:06pm UTC](https://forum.ansible.com/t/awx-max-postgresql-version-15/38300/6 "2023-08-16T18:06:11Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![AWX\_Project](https://avatars.discourse-cdn.com/v4/letter/a/eada6e/32.png) [@AWX\_Project](https://forum.ansible.com/u/AWX_Project)\
**Post date:** [August 23, 2023, 6:38pm UTC](https://forum.ansible.com/t/awx-max-postgresql-version-15/38300/7 "2023-08-23T18:38:50Z")

</div>

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

-AWX Team
