Re: Permission error - Mailing list pgsql-novice

From Carmical Casey
Subject Re: Permission error
Date
Msg-id Law9-F115W3yZty1sh40002fa26@hotmail.com
Whole thread Raw
In response to Permission error  ("Carmical Casey" <ccarmical@hotmail.com>)
List pgsql-novice
How do I figure out what user the postmaster is running as?  Changing the
permissions is easy.  By the way, I just looked, and postgresql is not in
/etc/rc.d/init.d/
Is that because I haven't restarted the server?

RH 7.3
Postgres 7.3

>"Carmical Casey" <ccarmical@hotmail.com> writes:
> > I reinstalled postgres, and now I am getting the following error when
> > trying to add a database:
> > psql: FATAL 1: cannot open /var/lib/pgsql/data/global/1262: Permission
> > denied
> > Any clues as to why this is happening and how to fix it?
>
>Sounds like you failed to make the Postgres data files be owned by the
>same user the postmaster is running as.
>
>If you determine that the file ownership needs to be changed, "chown -R"
>should help.
>
>            regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster

_________________________________________________________________
ウイルスメール、迷惑メール対策なら MSN Hotmail http://www.hotmail.com/


pgsql-novice by date:

Previous
From: Joe Conway
Date:
Subject: Re: Exponential display of values
Next
From: Tom Müller-Ackermann
Date:
Subject: FUNCTION REPLACE() "does not exist" ?