LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
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.

Notices


Reply
  Search this Thread
Old 10-01-2008, 12:59 PM   #1
ksmatthews
Member
 
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 ?

regards,

Steven M
 
Old 10-01-2008, 01:16 PM   #2
AuroraCA
Member
 
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
Anttim
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
ksmatthews
Member
 
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,

regards,

Steven M
 
  


Reply


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

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

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

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