Re: COPY from question

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: COPY from question
Date: 2004-02-03 04:07:05
Message-ID: 11229.1075781225@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-02-03 06:06:58 Re: [PATCHES] log session end - again
Previous Message Kris Jurka 2004-02-03 04:01:35 Re: COPY from question

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2004-02-03 04:08:42 Re: [PERFORM] MySQL+InnoDB vs. PostgreSQL test?
Previous Message Kris Jurka 2004-02-03 04:01:35 Re: COPY from question