| From: | Jim <azmode03(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Fwd: Can't populate database using Copy |
| Date: | 2006-08-26 20:16:40 |
| Message-ID: | 20060826201640.46123.qmail@web37901.mail.mud.yahoo.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
OK, disabled the SELinux , so can copy now; thanks for your time...
Jim <azmode03(at)yahoo(dot)com> wrote: Date: Sat, 26 Aug 2006 11:35:56 -0700 (PDT)
From: Jim <azmode03(at)yahoo(dot)com>
Subject: Can't populate database using Copy
To: pgsql-general(at)postgresql(dot)org
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2006-08-26 20:21:18 | Re: Content of pg_class.relacl |
| Previous Message | Michael Fuhr | 2006-08-26 20:10:31 | Re: Shared Objects (Dynamic loading) |