postgresql daemon is not properly set for debian9 (9.6)

[idanshimon]

postgresql daemon is not properly set for debian9 (9.6)

[idanshimon]

I discovered this issue after this error msg:

msg: unable to connect to database: FATAL: Peer authentication failed for user "postgres"

After checking my pg_hba configuration and seeing nothing was wrong with that i started to suspect the ansible role parameters. I've done the process manually and noticed the service is never really restarted.

This is the root cause for a lot of users who have Peer authentication error for default user postgres even after setting postgres user as "trust" (in the pg_hba file). Since the role cannot restart the database the pg_hba settings file is never applied - this can cause other major problems as well !

To workaround this issue simply set the following vars:

vars:
    postgresql_version: "9.6"
    postgresql_daemon: "postgresql@{{ postgresql_version }}-main"

I hope this post can help others

[tavinus]

This also applies to Debian Jessie with Postgres9.4.
On the few times we had reboots the postgres server did not come back.
Can't reboot right now but I enabled the @9.4 service with:

sudo systemctl enable [email protected]

[AlexGluck]

Tomorrow i check this issue and PR with fix. Thx

[AlexGluck]

I done fix for this in PR #47

[geerlingguy]

Testing a fix locally for Debian 8/9.

[DanielJulian]

THANK YOU SO MUCH!! Having this issue with postgresql-11 in ubuntu 18