RE: Permission denied while importing data from a file? - Mailing list pgsql-general

From Sampath, Krishna
Subject RE: Permission denied while importing data from a file?
Date
Msg-id EDD4714513C8D2118B940090273D1A8201183B3A@NJ01SNT11
Whole thread Raw
In response to Permission denied while importing data from a file?  (Felix Slager <slager@hydra.accu.uu.nl>)
List pgsql-general
maybe the directory '.../somebody' does not have read permission (700?)

krishna


-----Original Message-----
From: Adam Ruth [mailto:aruth@intercation.com]
Sent: Monday, April 10, 2000 9:54 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Permission denied while importing data from a
file?


I've gotten that message before when users couldn't read the directory the
file is in.

--
Adam Ruth
InterCation, Inc.
www.intercation.com
"Felix Slager" <slager@hydra.accu.uu.nl> wrote in message
news:38F0ACDC.CBCE5538@hydra.accu.uu.nl...
> LS,
>
> i'm trying to copy data into a table using a copy command using:
>
> COPY tabelName FROM '/somewhere/somebody/datafile.txt';
>
> I've given everybody the right to use the datafile.txt (execute, read,
> write) with an incredible chmod 7777. Still i get the message:
>
> ERROR:  COPY command, running in backend with effective uid nr 666,
> could not open file '/somewhere/somebody/datafile.txt' for reading.
> Errno = Permission denied (13).
>
> Why? I mean how does this happen?
> Please help...
>
> Felix


pgsql-general by date:

Previous
From: Andrew Schmeder
Date:
Subject: Re: recursive queries?
Next
From: "Sampath, Krishna"
Date:
Subject: RE: BLOB datatype