Postgres service doesnot start

Question

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

PostgreSQL version? What's the error message from the PostgreSQL log files when you try to start it? — Craig Ringer
– Craig Ringer, Commented May 20, 2015 at 4:57
When I start service with /etc/init.d/postgresql-9.4 start, It shows failed — Pragnesh
– Pragnesh, Commented May 20, 2015 at 5:27

user_0 · Accepted Answer · 2015-05-20 06:09:05Z

5

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

answered May 20, 2015 at 6:09

user_0

3,38323 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

Pragnesh Over a year ago

ThankX to reply, I always login with postgres user so user is postgres and I change the pg_hba.conf file permission even it is not started

user_0 Over a year ago

Is currently postgresql running with postgres user? How did you edit configuration file? (gedit, vi, ecc...)

Pragnesh Over a year ago

I change method ident to trust and it stops then I rollback the change but not started then

user_0 Over a year ago

Problem is gedit if it is on a remote machine (it rewrites the file, messing up permissions). Just login via shell and verify permission. I'm pretty sure problem is there.

Pragnesh Over a year ago

How to do that dear plz let me know

|

Collectives™ on Stack Overflow

Postgres service doesnot start

1 Answer 1

10 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Related