Re: COPY - permission denied

From: Dawid Kuroczko <qnex42(at)gmail(dot)com>
To: John Seberg <johnseberg(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY - permission denied
Date: 2005-09-23 14:15:06
Message-ID: 758d5e7f0509230715250611d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/23/05, John Seberg <johnseberg(at)yahoo(dot)com> wrote:
>
> 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.

Turn off or configure SELinux. The default policy prohibits
PostgreSQL from reading files from "weird" places, like
/tmp/ or similar.

Regards,
Dawid

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2005-09-23 14:18:08 Re: COPY - permission denied
Previous Message John Seberg 2005-09-23 14:03:44 COPY - permission denied