Re: [real] Re: copy command problem - Mailing list pgsql-general

From Don Isgitt
Subject Re: [real] Re: copy command problem
Date
Msg-id 3FE0BA5F.3040502@soundenergy.com
Whole thread Raw
In response to copy command problem  (Don Isgitt <djisgitt@soundenergy.com>)
List 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@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


pgsql-general by date:

Previous
From: manoj nahar
Date:
Subject: Re: Postgres respond after toomany times to a query view
Next
From: Christopher Murtagh
Date:
Subject: Re: Permissions issue?