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

Remove and reinstall it. Your data will remain intact.

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).

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