Обсуждение: Can't populate database using Copy
copy tabledaily from '/home/jb/FinalData.txt' with csv;
ERROR: could not open file "/home/jb/FinalData.txt" for reading: Permission denied. Yet everything else works, including populating tables with Insert queries.
All the permissions were changed for world access ( perhaps bad idea but out of frustration; and am the only person on this computer ).
drwxrwxrwx 3 root root 4096 Aug 21 10:19 home
drwxrwxrwx 25 jb jb 4096 Aug 26 11:18 jb
-rwxrwxrwx 1 jb jb 255 Aug 25 18:15 FinalData.txt
I see other people with this same problem on the mailing lists, but no example-solutions are offered. Can you get the newbys started ? Thanks.
ERROR: could not open file "/home/jb/FinalData.txt" for reading: Permission denied. Yet everything else works, including populating tables with Insert queries.
All the permissions were changed for world access ( perhaps bad idea but out of frustration; and am the only person on this computer ).
drwxrwxrwx 3 root root 4096 Aug 21 10:19 home
drwxrwxrwx 25 jb jb 4096 Aug 26 11:18 jb
-rwxrwxrwx 1 jb jb 255 Aug 25 18:15 FinalData.txt
I see other people with this same problem on the mailing lists, but no example-solutions are offered. Can you get the newbys started ? Thanks.
On Sat, Aug 26, 2006 at 11:35:56AM -0700, Jim wrote: > copy tabledaily from '/home/jb/FinalData.txt' with csv; > ERROR: could not open file "/home/jb/FinalData.txt" for reading: Permission denied. > Yet everything else works, including populating tables with Insert queries. > > All the permissions were changed for world access ( perhaps bad idea > but out of frustration; and am the only person on this computer ). > drwxrwxrwx 3 root root 4096 Aug 21 10:19 home > drwxrwxrwx 25 jb jb 4096 Aug 26 11:18 jb > -rwxrwxrwx 1 jb jb 255 Aug 25 18:15 FinalData.txt Might this be an SELinux problem? -- Michael Fuhr
Try this:
copy the file "FinalData.txt" to the 'bin' folder of pgsql where postgres binaries are located and then try doing the COPY using
copy tabledaily from 'FinalData.txt ' with csv;
and see if it solves the problem or not?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
copy the file "FinalData.txt" to the 'bin' folder of pgsql where postgres binaries are located and then try doing the COPY using
copy tabledaily from 'FinalData.txt ' with csv;
and see if it solves the problem or not?
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 8/27/06, Michael Fuhr <mike@fuhr.org> wrote:
On Sat, Aug 26, 2006 at 11:35:56AM -0700, Jim wrote:
> copy tabledaily from '/home/jb/FinalData.txt' with csv;
> ERROR: could not open file "/home/jb/FinalData.txt" for reading: Permission denied.
> Yet everything else works, including populating tables with Insert queries.
>
> All the permissions were changed for world access ( perhaps bad idea
> but out of frustration; and am the only person on this computer ).
> drwxrwxrwx 3 root root 4096 Aug 21 10:19 home
> drwxrwxrwx 25 jb jb 4096 Aug 26 11:18 jb
> -rwxrwxrwx 1 jb jb 255 Aug 25 18:15 FinalData.txt
Might this be an SELinux problem?
--
Michael Fuhr
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster