| From: | raghu_k_n(at)yahoo(dot)com (Raghu) |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: New at this. Commissioning for the first time: |
| Date: | 2004-01-14 08:45:09 |
| Message-ID: | 55764c13.0401140045.9e5cf3a@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
sa92003(at)yahoo(dot)com (Rob) wrote in message news:<6b5b067f(dot)0401112211(dot)2b926246(at)posting(dot)google(dot)com>...
> 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.
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raghu | 2004-01-14 09:00:33 | Meta data about object in postgres |
| Previous Message | Bruno LEVEQUE | 2004-01-14 07:38:10 | Re: (no subject) |