Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin

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
[root(at)callisto init.d]# chmod 755

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

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


-Jan Muhammad



pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group