Hi Everyone,

I'm brand new at this, and am trying to set up PostgreSQL for the very
first time. It looks like my installation of RH9 a few weeks ago has
installed the database proper, and now all I need to do is create a
few files and commission the application so that I can see "template1"
and proceed from there.

I had set up the directory...
/usr/local/pgsql/data

and then typed...
postmaster -D /usr/local/pgsql/data

and the shell reply is...
FATAL: data directory /usr/local/pgsql/data has group or world
access;
permissions should be u=rwx (0700)

Being new at Un*x as well, I only know a fair amount about how to
change permissions. Emacs says the directory currently has these
permissions on the directory:
drwxr-xr-x

What instructions should I issue in order to meet the requirement?
chmod [what?]

Thank you for any information that you can provide.

sa92003 (AT) yahoo (DOT) com (Rob) wrote in message news:<6b5b067f.0401112211.2b926246 (AT) posting (DOT) google.com>...
Rob,
Unix user running the postmaster needs to own /usr/local/pgsql/data
directory.
Do the following : ( i assume that you have postgres unix user and
data directory exists)
1. chown postgres /usr/local/pgsql/data
2. su postgres
3. postmaster -D /usr/local/pgsql/data
4. pg_ctl status

Essentially make postgres user the owner of data directory and then
run postmaster as postgres.

sa92003 (AT) yahoo (DOT) com (Rob) writes:
If you are familiar with octal notation you'd just do

chmod 700 /usr/local/pgsql/data

but a more symbolic way is

chmod go-rx /usr/local/pgsql/data

(which says to remove R and X permissions for Group and Other).

Note that you cannot start the postmaster on an empty data directory;
you have to run initdb first. Had you run initdb, it'd have fixed
the permissions for you, so really you can forget the above and just
do

initdb -D /usr/local/pgsql/data

then run the postmaster.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings