Re: Permission error - Mailing list pgsql-novice

From Tom Lane
Subject Re: Permission error
Date
Msg-id 22237.1060093360@sss.pgh.pa.us
Whole thread Raw
In response to Permission error  ("Carmical Casey" <ccarmical@hotmail.com>)
List pgsql-novice
"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

pgsql-novice by date:

Previous
From: HK
Date:
Subject: Exponential display of values
Next
From: Nabil Sayegh
Date:
Subject: pg_dump schema