Reputation: 41
I have issue with postgres. It stops due to change in pg_hba.conf
file
Actually my postgres was not connect with PHP
So I change in method in /var/lib/pgsql/data/pg_hba.conf
file:
TYPE DATABASE USER ADDRESS METHOD
host all all 127.0.0.1/32 ident
In order to solve my connection error i change the method ident to trust and postgresql servicer stops
I rollback my changes even it not started.
The error is:
LOG: could not open configuration file "/var/lib/pgsql/9.4/data/pg_hba.conf": Permission denied
Upvotes: 3
Views: 4325
Reputation: 3363
I'm assuming that postgresql is running with postgres user, as in a standard configuration.
From terminal, as root:
ls -l /var/lib/pgsql/9.3/data/pg_hba.conf
And verify the owner. If the owner is not postgres:
chown postgres:postgres pg_hba.conf
And be sure it has permission to read and write:
chmod u+rwx pg_hba.conf
Upvotes: 5