Re: Permission error

From: "Carmical Casey" <ccarmical(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Permission error
Date: 2003-08-05 23:13:26
Message-ID: Law9-F115W3yZty1sh40002fa26@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hotmail(dot)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/

Browse pgsql-novice by date

  From Date Subject
Next Message Ritesh Bhatnagar 2003-08-06 03:28:21
Previous Message Joe Conway 2003-08-05 16:41:32 Re: Exponential display of values