Re: COPY from question - Mailing list pgsql-hackers

From Tom Lane
Subject Re: COPY from question
Date
Msg-id 11229.1075781225@sss.pgh.pa.us
Whole thread Raw
In response to COPY from question  (Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au>)
List pgsql-hackers
Slavisa Garic <Slavisa.Garic@infotech.monash.edu.au> writes:
> ... I get the following error on Linux
> machine even if permissions on the data file are 777:

>   _pg.error: ERROR:  COPY command, running in backend with effective uid
>   26, could not open file '/home/slavisa/.nimrod/experiments/demo/ejdata'
>   for reading.  Errno = Permission denied (13).

Most likely the postgres user doesn't have read permission for one of
the directories in that path.
        regards, tom lane

PS: this didn't really belong on pghackers.


pgsql-hackers by date:

Previous
From: Kris Jurka
Date:
Subject: Re: COPY from question
Next
From: Andrew Dunstan
Date:
Subject: Re: [PATCHES] log session end - again