Re: COPY - permission denied - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY - permission denied
Date
Msg-id 3772.1127486321@sss.pgh.pa.us
Whole thread Raw
In response to COPY - permission denied  (John Seberg <johnseberg@yahoo.com>)
Responses Re: COPY - permission denied
List pgsql-general
John Seberg <johnseberg@yahoo.com> writes:
> I have used the COPY command dozens of times! I think
> I *get* it. But, I'm getting "permission denied"
> errors.

> This is a fresh install of Fedora Core 4 (x86). I have
> Postgresql running under the user postgres. I am
> logged into to psql as postgres. The files are owned
> by postgres and are -rw-------. They are being found -
> it isn't a "file not found" error.

Do you have SELinux running in enforcement mode?  If so, it's likely
denying the server the privilege to read or write anywhere outside
/var/lib/pgsql.  Check for messages about this in /var/log/messages.

            regards, tom lane

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Questions about Rollback - after insert, update,
Next
From: Bruno Wolff III
Date:
Subject: Re: How many insert + update should one transaction handle?