Download your favorite Linux distribution at LQ ISO.
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 10-01-2008, 12:59 PM   #1
Registered: Aug 2008
Posts: 86

Rep: Reputation: 15
Question postgres blues

HI There,

I am having problems with postgres sql on open SUSE Linux 10.3. Everything worked well until my controls froze up and I had to switch off my machine and restart it again manually.
Now postgres is down and I cannot restart it !!

I have tried using yast2 to check the run time level and that displays a yes* for postgres. I have tried to disable and enable through yast2 but these both return a 1 (errror).

I have also tried these commands

linux-v5rh:/home/steven # rcpostgresql status
Checking for PostgreSQL: unused

linux-v5rh:/home/steven # rcpostgresql start
Starting PostgreSQL2008-10-01 17:55:57 BST FATAL: data directory "/var/lib/pgsql/data" has group or world access
2008-10-01 17:55:57 BST DETAIL: Permissions should be u=rwx (0700).

Nothing seems to work ....

Can anyone advise ?


Steven M
Old 10-01-2008, 01:16 PM   #2
Registered: Jul 2008
Location: Northern CA USA
Distribution: Ubuntu, Slackware, Gentoo, Fedora, Red Hat, Puppy Linux
Posts: 370

Rep: Reputation: 35
Remove and reinstall it. Your data will remain intact.
Old 10-01-2008, 01:49 PM   #3
LQ Newbie
Registered: Jul 2008
Location: Finland
Distribution: Debian (Sid)
Posts: 8

Rep: Reputation: 0
The error message contains a solution :-). PostgreSQL requires that the database files are accessible by the Postgres user only => Simply update the directory permissions of the data-directory as root with chmod command: chmod 700 data. If this does not help you should make sure that the owner user and group are postgres - postgres respectively (check the actual user and group names from your system).

Come to think of it, easiest may solution may be to execute command 'initdb'. It will initialize your data dir so that it works. It will not destroy any data. Check the usage details from the PostgreSQL manual (or man command).

Last edited by Anttim; 10-01-2008 at 01:51 PM.
Old 10-01-2008, 03:26 PM   #4
Registered: Aug 2008
Posts: 86

Original Poster
Rep: Reputation: 15
Thanks ....

Thanks Anttim,

RE Simply update the directory permissions of the data-directory as root with chmod command: chmod 700 data

That seems to have sorted my problem,


Steven M


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Changes in postgres without restarting postgres venki Linux - General 3 07-19-2007 02:06 AM
New uses blues SVwander Fedora - Installation 4 03-05-2006 05:23 PM
Postgres Hiper1 Linux - Newbie 8 04-10-2005 06:43 PM
starting postgres 7.2.2 lolmc Linux - Software 4 02-26-2003 04:30 PM
postgres connect richard22 Linux - Software 4 01-29-2003 01:42 PM > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:06 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration