PostgreSQL acess

Archives AWX Project
1

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

2

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