Postgres Pro
Downloads
Home   >   mailing lists

Re: Can't populate database using Copy - Mailing list pgsql-general

From Shoaib Mir
Subject Re: Can't populate database using Copy
Date
Msg-id bf54be870608270611t4d062bfcy71117cb3d34b36d8@mail.gmail.com
Whole thread Raw
In response to Re: Can't populate database using Copy  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view
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)


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




pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Cutting the Gborg throat
Next
From: Tom Lane
Date:
Subject: Re: speeding up big query lookup