Re: Can't populate database using Copy

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jim <azmode03(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Can't populate database using Copy
Date: 2006-08-26 20:42:58
Message-ID: 20060826204258.GA46679@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Stark 2006-08-26 20:47:33 Re: Something blocking in libpq_gettext?
Previous Message Michael Fuhr 2006-08-26 20:36:28 Re: Inserting Data