# PostgreSQL acess

**URL:** <https://forum.ansible.com/t/postgresql-acess/30820>\
**Category:** AWX Project\
**Tags:** awx\
**Created:** [July 19, 2019, 10:36am UTC](https://forum.ansible.com/t/postgresql-acess/30820 "2019-07-19T10:36:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ahmed\_kim](https://avatars.discourse-cdn.com/v4/letter/a/c2a13f/32.png) [@ahmed\_kim](https://forum.ansible.com/u/ahmed_kim)\
**Post date:** [July 19, 2019, 10:36am UTC](https://forum.ansible.com/t/postgresql-acess/30820/1 "2019-07-19T10:36:50Z")

</div>

I figured out how to acess the PostgreSQL database of my AWX project and i want to know in which scheme do the number of failed hosts or the project in the dashboard go to?  
Thank you

---

<div class="post-metadata">

**Author:** ![Nivedita](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@Nivedita](https://forum.ansible.com/u/Nivedita)\
**Post date:** [August 19, 2019, 4:56am UTC](https://forum.ansible.com/t/postgresql-acess/30820/2 "2019-08-19T04:56:03Z")

</div>

Hi Ahmed,

You can access postgres database in AWX by using below steps:

1. To access postgres databse:  
#docker exec -it postgres /bin/bash

2. Login with user ‘awx’

# psql -U awx

1. Below step will show you list of database available:

# \list

1. Connect with database ‘awx’  
#\c awx
2. Fetch list of all tables in databse:  
#\d
3. Search in hosts related table

Regards