Re: Permission error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Carmical Casey" <ccarmical(at)hotmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Permission error
Date: 2003-08-05 14:22:40
Message-ID: 22237.1060093360@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Müller-Ackermann 2003-08-05 14:54:20 FUNCTION REPLACE() "does not exist" ?
Previous Message HK 2003-08-05 11:19:57 Exponential display of values