How to run PostgreSQL? - Mailing list pgsql-admin

From Jan Muhammad
Subject How to run PostgreSQL?
Date
Msg-id 786080.4059.qm@web38704.mail.mud.yahoo.com
Whole thread Raw
Responses Re: How to run PostgreSQL?  (Ray Stell <stellr@cns.vt.edu>)
Re: How to run PostgreSQL?  (lst_hoe02@kwsoft.de)
List pgsql-admin
Hi,

I have just downloaded, installed/configured postgresql version 8.2.11 on Fedora Core 6. While reading through the installation manual have setup most of its parts; now while trying to run datebase server with the command:  
$ postmaster -D /usr/local/pgsql/data

I get the following error:

"FATAL:  data directory "/usr/local/pgsql/data" has group or world access
DETAIL:  Permissions should be u=rwx (0700)."

Although I'm running this command from user 'postgres'; who has the ownership of /pgsql/data directories as well.

Secondly, when I try to check that postgresql service is running or not; with the command: # service postgrsql status
postgrsql: unrecognized service

Again when I configured all it stuff, like the following among several things:

[root@callisto]#  cp /usr/local/pgsql/postgresql-8.2.11/contrib/start-scripts/linux /etc/init.d/postgres

[root@callisto init.d]# chmod 755 /etc/init.d/postgres

[root@callisto init.d]# gedit /etc/init.d/postgres

[root@callisto init.d]# ln -s /etc/init.d/postgres /etc/rc2.d/S85postgres

[root@callisto init.d]# ln -s /etc/init.d/postgres /etc/rc3.d/S85postgres

[root@callisto init.d]# /etc/init.d/postgres start

Starting PostgreSQL: ok
I wonder what is the best way to get PostgreSQL working? Any help in this regard will be highly appreciated..

Regards

-Jan Muhammad


pgsql-admin by date:

Previous
From: Michael Monnerie
Date:
Subject: Re: Why postgresql 8.3.5 created temporary files of size less then work_mem on disk ?
Next
From: Ray Stell
Date:
Subject: Re: How to run PostgreSQL?