From: | Don Isgitt <djisgitt(at)soundenergy(dot)com> |
---|---|
To: | Bernd Helmle <mailings(at)oopsware(dot)de> |
Cc: | postgresql general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: [real] Re: copy command problem |
Date: | 2003-12-17 20:19:43 |
Message-ID: | 3FE0BA5F.3040502@soundenergy.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Bernd Helmle wrote:
> Don Isgitt wrote:
>
>> Hi,
>>
>> gds2=# copy survey_match from '/home/djisgitt/perl/fixsvy.dat' with
>> delimiter as '>';
>> ERROR: could not open file "/home/djisgitt/perl/fixsvy.dat" for
>> reading: Permission denied
>>
>> File sysem permissions are
>>
>> [djisgitt(at)dbserver perl]$ ls -l /home/djisgitt/perl/fixsvy.dat
>> -rwxrwxrwx 1 djisgitt djisgitt 198441 Nov 5 12:35
>> /home/djisgitt/perl/fixsvy.dat
>>
>
> Check, if your home and subdirectories has sufficient permissions: you
> need at least r-x for others on the specific directories, otherwise
> your backend is not able to access your dump.
>
> chmod o+rx /home/djisgitt should do the job, i think
>
> Bernd
>
>
>
>
Thank you, Bernd; that was the problem. I obviously didn't think about
the forest, since the tree was ok. :-[
Don
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-12-17 20:25:37 | Re: Permissions issue? |
Previous Message | Marc G. Fournier | 2003-12-17 20:08:04 | bind-dlz with postgresql driver ... |