# Error on installing AWX's Postgres node

**URL:** <https://forum.ansible.com/t/error-on-installing-awxs-postgres-node/34165>\
**Category:** AWX Project\
**Tags:** awx, kubernetes\
**Created:** [November 6, 2020, 9:15pm UTC](https://forum.ansible.com/t/error-on-installing-awxs-postgres-node/34165 "2020-11-06T21:15:14Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![cscal](https://avatars.discourse-cdn.com/v4/letter/c/59ef9b/32.png) [@cscal](https://forum.ansible.com/u/cscal)\
**Post date:** [November 6, 2020, 9:15pm UTC](https://forum.ansible.com/t/error-on-installing-awxs-postgres-node/34165/1 "2020-11-06T21:15:14Z")

</div>

Hello!

I’m testing an installation of AWX to a multi-node cluster with an external database, and when it gets to the “Start the containers” task, I get this error for the Postgres node:

The full traceback is:  
File “/tmp/ansible\_docker\_compose\_payload\_rvms0n\_l/ansible\_docker\_compose\_payload.zip/ansible/module\_utils/docker/common.py”, line 361, in **init**  
super(AnsibleDockerClient, self). **init** (\*\*self.\_connect\_params)  
File “/usr/local/lib/python3.6/site-packages/docker/api/client.py”, line 188, in **init**  
self.\_version = self.\_retrieve\_server\_version()  
File “/usr/local/lib/python3.6/site-packages/docker/api/client.py”, line 213, in \_retrieve\_server\_version  
‘Error while fetching server API version: {0}’.format(e)  
fatal: [postgres1.home.local]: FAILED! =\> {  
“changed”: false,  
“invocation”: {  
“module\_args”: {  
“api\_version”: “auto”,  
“build”: false,  
“ca\_cert”: null,  
“client\_cert”: null,  
“client\_key”: null,  
“debug”: false,  
“definition”: null,  
“dependencies”: true,  
“docker\_host”: “unix://var/run/docker.sock”,  
“files”: null,  
“hostname\_check”: false,  
“nocache”: false,  
“project\_name”: null,  
“project\_src”: “/root/.awx/awxcompose”,  
“pull”: false,  
“recreate”: “smart”,  
“remove\_images”: null,  
“remove\_orphans”: false,  
“remove\_volumes”: false,  
“restarted”: true,  
“scale”: null,  
“services”: null,  
“ssl\_version”: null,  
“state”: “present”,  
“stopped”: false,  
“timeout”: 10,  
“tls”: false,  
“tls\_hostname”: “localhost”,  
“validate\_certs”: false  
}  
},

“Error connecting: Error while fetching server API version: (‘Connection aborted.’, FileNotFoundError(2, ‘No such file or directory’))”

Here is my (sanitized) inventory file:

[tower]  
ansible.home.local  
ansible2.home.local

[database]  
postgres1.home.local

[all:vars]  
ansible\_become=true  
ansible\_user=ansible  
ansible\_password=‘’  
ansible\_become\_password=‘’  
ansible\_python\_interpreter=“/usr/bin/env python3”

# Remove these lines if you want to run a local image build

# Otherwise the setup playbook will install the official Ansible images. Versions may

# be selected based on: latest, 1, 1.0, 1.0.0, 1.0.0.123

# by default the base will be used to search for ansible/awx

dockerhub\_base=ansible

# Common Docker parameters

awx\_task\_hostname=awx  
awx\_web\_hostname=awxweb  
host\_port=80  
host\_port\_ssl=443  
#ssl\_certificate=

# Optional key file

#ssl\_certificate\_key=  
docker\_compose\_dir=“~/.awx/awxcompose”

# Set pg\_hostname if you have an external postgres server, otherwise

# a new postgres service will be created

# pg\_hostname=postgresql

pg\_host=‘postgres1.home.local’  
pg\_username=awx

# pg\_password should be random 10 character alphanumeric string, when postgresql is running on kubernetes

# NB: it’s a limitation of the “official” postgres helm chart

pg\_password=‘’  
pg\_database=awx  
pg\_port=5432  
#pg\_sslmode=require  
postgres\_data\_dir=“/data”

rabbitmq\_port=5672  
rabbitmq\_vhost=tower  
rabbitmq\_username=tower  
rabbitmq\_password=tower  
rabbitmq\_cookie=rabbitmqcookie

# This will create or update a default admin (superuser) account in AWX, if not provided

# then these default values are used

admin\_user=admin  
admin\_password=‘’

# Whether or not to create preload data for demonstration purposes

create\_preload\_data=True

# AWX Secret key

# It’s _very_ important that this stay the same between upgrades or you will lose the ability to decrypt

# your credentials

secret\_key=awxsecret

What file or directory is Ansible referring to in the error? The postgres data dir definitely exists and is mounted (it’s currently empty). Docker compose is installed and the .awx/awxcompose directory exists.