Postgresql fatal error

Question

I am using postgresql. By mistake i gave permission to the postgresql folder through the command

chmod -R 777 /var/lib/postgresql/

Now that when i am trying to connect to postgresql it is giving me the following error.

The PostgreSQL server failed to start. Please check the log output:
2013-09-19 07:21:48 GMT FATAL:  data directory
"/var/lib/postgresql/8.4/main" has group or world access 2013-09-19
07:21:48 GMT DETAIL:  Permissions should be u=rwx (0700).

tried restarting postgresql server through command

/etc/init.d/postgresql restart

but getting the same error.

what shall i do?

Doesn’t the message already tell you what you should do …? — C3roe
– C3roe, Commented Sep 19, 2013 at 7:48

Chris Travers · Accepted Answer · 2013-11-17 07:11:53Z

9

PostgreSQL requires exclusive access to the files in the data directory. This is fixable depending on your operating system by using chmod 700 on the data directory or by right-clicking, and selecting various options on Windows.

answered Nov 17, 2013 at 7:11

Chris Travers

26.6k6 gold badges70 silver badges191 bronze badges

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

Collectives™ on Stack Overflow

Postgresql fatal error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related