Impossible to start postresql
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OpenStack DBaaS (Trove) |
New
|
Undecided
|
Unassigned |
Bug Description
Hello,
Postgres version - 9.4
# dpkg -l | grep -i trove
ii python-trove 1:6.0.0-
ii trove-common 1:6.0.0-
ii trove-guestagent 1:6.0.0-
Trove rewrites access rules and a postgres cluster is not able to start due to access restrictions:
# /usr/bin/
Warning: connection to the database failed, disabling startup checks:
psql: FATAL: role "postgres" is not permitted to log in
$ psql
psql: FATAL: role "postgres" is not permitted to log in
# cat /etc/postgresql
local all postgres,os_admin trust
local all all md5
local replication postgres,os_admin trust
host all postgres,os_admin 127.0.0.1/32 trust
host all postgres,os_admin ::1/128 trust
host all postgres,os_admin localhost trust
host all os_admin 0.0.0.0/0 reject
host all os_admin ::/0 reject
host all all 0.0.0.0/0 md5
host all all ::/0 md5
Clearly there has to be some reason why this isn't working for you given that postgres does in fact work (in the gate, for example). Absent any steps to repro this problem, or a description of why it is happening, I'm marking this incomplete for now.