Re: copy command - Mailing list pgsql-general

From Tom Lane
Subject Re: copy command
Date
Msg-id 17529.1156653413@sss.pgh.pa.us
Whole thread Raw
In response to Re: copy command  (Gregory Stark <gsstark@mit.edu>)
List pgsql-general
Gregory Stark <gsstark@mit.edu> writes:
> Jim Bryan <gooddayarizona@yahoo.com> writes:
>> "/home/jb/Desktop/DateTimeData.txt" for reading:
>> Permission denied
>>
>> -rw-rw-r-- 1 jb   jb         83 Aug 25 14:30
>> DateTimeData.txt

> I suspect it doesn't have "x" permission on some parent directory,

Yeah, user home directories are not normally world-readable in Fedora.
Even if you've made yours readable, the default SELinux policy in FC5
prevents daemons such as the PG postmaster from accessing random parts
of the filesystem.

Consider using psql's \copy instead.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Cutting the Gborg throat
Next
From: "Joshua D. Drake"
Date:
Subject: jabber.postgresql.org is up