| 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: | Whole Thread | Raw Message | 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 ... |