Re: [real] Re: copy command problem

Поиск
Список
Период
Сортировка
От Don Isgitt
Тема Re: [real] Re: copy command problem
Дата
Msg-id 3FE0BA5F.3040502@soundenergy.com
обсуждение исходный текст
Ответ на copy command problem  (Don Isgitt <djisgitt@soundenergy.com>)
Список 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 по дате отправления:

Предыдущее
От: manoj nahar
Дата:
Сообщение: Re: Postgres respond after toomany times to a query view
Следующее
От: Christopher Murtagh
Дата:
Сообщение: Re: Permissions issue?