# AWX install issue with external postgres

**URL:** <https://forum.ansible.com/t/awx-install-issue-with-external-postgres/32398>\
**Category:** AWX Project\
**Tags:** rhel, awx\
**Created:** [March 5, 2020, 9:34pm UTC](https://forum.ansible.com/t/awx-install-issue-with-external-postgres/32398 "2020-03-05T21:34:08Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bharat\_Maddirala](https://avatars.discourse-cdn.com/v4/letter/b/a5b964/32.png) [@Bharat\_Maddirala](https://forum.ansible.com/u/Bharat_Maddirala)\
**Post date:** [March 5, 2020, 9:34pm UTC](https://forum.ansible.com/t/awx-install-issue-with-external-postgres/32398/1 "2020-03-05T21:34:08Z")

</div>

##### **ISSUE TYPE**

Web UI not working after trying to access the hostname url.

##### **SUMMARY**

So , I have installed AWX and it is connected to an external DB which also on a RHEL 8 VM.  
After installing the awx , I am trying to connect to the UI but it showing as the awx box refused to connect.

I am able to telnet from my host vm to the database server but somehow awx install is not able to talk to DB

Please Help

##### **ENVIRONMENT** - AWX version: latest

- AWX install method: docker on linux
- Ansible version: 2.9.3
- Operating System: RHEL 8.1
- Web Browser: google chrome

---

<div class="post-metadata">

**Author:** ![Dan\_W1](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@Dan\_W1](https://forum.ansible.com/u/Dan_W1)\
**Post date:** [March 6, 2020, 2:54pm UTC](https://forum.ansible.com/t/awx-install-issue-with-external-postgres/32398/2 "2020-03-06T14:54:31Z")

</div>

Seeing similar errors as in [https://groups.google.com/forum/#!topic/awx-project/s87bZ64HLIQ](https://groups.google.com/forum/#!topic/awx-project/s87bZ64HLIQ)

Admittedly, there are differences in the installation (e.g. CentOS 8 vs RHEL 8, External Postgres vs PG Container), however, the thread discusses the fact that there are communication issues between awx\_task and Postgres.

Take a look at the firewall settings for the AWX Docker network (awxcompose\_default) by default.

Hope that helps.

---

<div class="post-metadata">

**Author:** ![Bharat\_Maddirala](https://avatars.discourse-cdn.com/v4/letter/b/a5b964/32.png) [@Bharat\_Maddirala](https://forum.ansible.com/u/Bharat_Maddirala)\
**Post date:** [March 6, 2020, 6:07pm UTC](https://forum.ansible.com/t/awx-install-issue-with-external-postgres/32398/3 "2020-03-06T18:07:30Z")

</div>

I did the changes, I will post my findings on the below thread

---

<div class="post-metadata">

**Author:** ![Ajitkumar\_Tanwade](https://avatars.discourse-cdn.com/v4/letter/a/bbce88/32.png) [@Ajitkumar\_Tanwade](https://forum.ansible.com/u/Ajitkumar_Tanwade)\
**Post date:** [March 31, 2020, 2:22pm UTC](https://forum.ansible.com/t/awx-install-issue-with-external-postgres/32398/4 "2020-03-31T14:22:19Z")

</div>

Hi Bharat,

We are also getting the same error. May I know how did you fix it?

Regards,  
Ajit

---

<div class="post-metadata">

**Author:** ![Ankit2](https://avatars.discourse-cdn.com/v4/letter/a/ea5d25/32.png) [@Ankit2](https://forum.ansible.com/u/Ankit2)\
**Post date:** [April 3, 2020, 8:39am UTC](https://forum.ansible.com/t/awx-install-issue-with-external-postgres/32398/5 "2020-04-03T08:39:09Z")

</div>

I remember using an external PG DB on a different RHEL server. I also remember allowing incoming connection in the Db config files when i was able to see connection errors to db.

Try validating if the following files are configured to accept incoming connections:

**/var/lib/pgsql/12/data/postgresql.conf**

`listen_addresses = '*'`

**/var/lib/pgsql/12/data/pg\_hba.conf**

`host all all 0.0.0.0/0 md5`

If no, make the changes and restart db service.

`systemctl restart postgresql-12`

Here, my pg version is 12.x