Search Postgresql Archives

Re: copy command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Gregory Stark <gsstark@xxxxxxx> writes:
> Jim Bryan <gooddayarizona@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux