How to run PostgreSQL?

From: Jan Muhammad <janmuhd(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to run PostgreSQL?
Date: 2009-05-07 11:38:59
Message-ID: 786080.4059.qm@web38704.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)callisto]#  cp
/usr/local/pgsql/postgresql-8.2.11/contrib/start-scripts/linux
/etc/init.d/postgres
[root(at)callisto init.d]# chmod 755
/etc/init.d/postgres

[root(at)callisto init.d]# gedit
/etc/init.d/postgres

[root(at)callisto init.d]# ln -s
/etc/init.d/postgres /etc/rc2.d/S85postgres
[root(at)callisto init.d]# ln -s
/etc/init.d/postgres /etc/rc3.d/S85postgres
[root(at)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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ray Stell 2009-05-07 12:26:04 Re: How to run PostgreSQL?
Previous Message Michael Monnerie 2009-05-06 19:25:30 Re: Why postgresql 8.3.5 created temporary files of size less then work_mem on disk ?