CODEWITHSUNDEEP
postgresql
Geek
Geek

Reputation: 555

Postgresql fatal error

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?

Upvotes: 7

Views: 10033

Answers (1)

Chris Travers
Chris Travers

Reputation: 26474

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.

Upvotes: 9

Related Questions