postgres is not able to login to verify existence of database about ansible-role-postgresql

[FilBot3]

Switching the databases.yml and users.yml yielded new errors.

TASK [geerlingguy.postgresql : Ensure PostgreSQL is started and enabled on boot.] ***************************************************************************************************
ok: [10.144.0.137]

TASK [geerlingguy.postgresql : Ensure PostgreSQL users are present.] ****************************************************************************************************************
failed: [10.144.0.137] (item=None) => {"censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false}
fatal: [10.144.0.137]: FAILED! => {"censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false}

[IDerr]

Had the same issue today with ansible galaxy version

[jpboliv]

I was experiencing a similar issue with the following failure
TASK [geerlingguy.postgresql : Ensure PostgreSQL users are present.] ***************************** failed: [production] (item=None) => {"censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false} fatal: [production]: FAILED! => {"censored": "the output has been hidden due to the fact that 'no_log: true' was specified for this result", "changed": false}

I recommend you to try setting postgres_users_no_log: false on your variables file and see what the error is about. In my case, it was related to the dependency psycopg2 (which I was already installing with python3-psycopg2, but was missing ansible_python_interpreter: /usr/bin/python3 on my variables)

[FilBot3]

Seems to be related to this: PR #31

on these lines:

• https://github.com/geerlingguy/ansible-role-postgresql/blob/master/tasks/main.yml#L21-L23

[abdrehma]

@predatorian3 I just tested this in case you're wondering:

This occurs because users are created before databases. So when you create a user and reference a database - there's no database to reference and it errors out

And then you create a database to reference a user - well, there's no user. You have to create a user first with no db reference, then create the db.

[stale]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.

[stale]

This issue is no longer marked for closure.

[stale]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.

[ahmedbodi]

Experiencing the same issue too

[stale]

This issue is no longer marked for closure.

[stale]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.

[ahmedbodi]

not stale

[stale]

This issue is no longer marked for closure.

[stale]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.

[ahmedbodi]

not stale

[stale]

This issue is no longer marked for closure.

[stale]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

Please read this blog post to see the reasons why I mark issues as stale.

[stale]

This issue has been closed due to inactivity. If you feel this is in error, please reopen the issue or file a new issue with the relevant details.