John Seberg <johnseberg@xxxxxxxxx> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq