Re: [real] Re: copy command problem

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

In response to

Browse pgsql-general by date

  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 ...