Postgres Pro
Downloads
Home   >   mailing lists

Thread: Permission denied while importing data from a file?

Permission denied while importing data from a file?

From
Felix Slager
Date:
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

Re: Permission denied while importing data from a file?

From
Charles Tassell
Date:
Try moving the file into /tmp and seeing if that works.  Sometimes you run
into problems with having permissiosn on the file, but not all of the
directories before it.  You must have execute permissions on all parent
directories in order to access a file in one of those dirs.   The file will
only need read access (444), although the others won't stop it from working
(it will just be less secure if you are on a multi-user system.)

Also, I believe that one of the copy commands (either \copy or the COPY SQL
command) can only be done as the database super user (postgres or pgsql,
depending on how you installed Postgres)  Maybe you are using the wrong one?

At 01:16 PM 4/9/00, you wrote:
>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

Re: Permission denied while importing data from a file?

From
"Adam Ruth"
Date:
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

RE: Permission denied while importing data from a file?

From
"Sampath, Krishna"
Date:
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