John Seberg <johnseberg(at)yahoo(dot)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