awx-operator
awx-operator copied to clipboard
ansible
FATAL: Role "postgres" does not exist, in postgres container logs
ISSUE TYPE
FATAL: Role "postgres" does not exist, in awx-postgres-0 log.
SUMMARY
Debugging Kubernetes related problems, after fixing them all postgres database never gets created, and logs repeat the same line.
FATAL: Role "postgres" does not exist, in postgres container logs
ENVIRONMENT
- Operator version: 0.13.0
- Kubernetes version:
@techzilla do you have any more information?
If you explicitly delete all the postgres things and then re-run the operator does it fix it?
I'm seeing the same problem. It's worked a few times but as I uninstall/re-install to work on some automation, it may work or it may not. In some cases, it starts to work for an unknown reasons (after restarting for hours). I've tried to delete everything but it doesn't consistently fix the problem. 2022-05-06 15:26:51.782 UTC [34] FATAL: password authentication failed for user "postgres" 2022-05-06 15:26:51.782 UTC [34] DETAIL: Role "postgres" does not exist. Connection matched pg_hba.conf line 99: "host all all all scram-sha-256"
Operator .20 Kubernetes 1.21
The same issue here on AWX 19.5.1, my awx instance might have been recreated for some reasons (but PVC is always there), then i found this password authentication issue. The secret in awx-postgres-configuration should be correct, is awx connecting postgres db with the credential in this secret?
