Skip site navigation (1) Skip section navigation (2)

Re: On Postgres and permissions, cant read a file into a table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Lars Forseth <larsf(at)powertech(dot)no>
Cc: "Suse-linux-e" <suse-linux-e(at)suse(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: On Postgres and permissions, cant read a file into a table
Date: 2001-03-25 16:48:07
Message-ID: 11336.985538887@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Lars Forseth <larsf(at)powertech(dot)no> writes:
> "COPY "Gravtype" FROM '/home/larsf/DATA/gravtype.txt' USING DELIMITERS '"'

> PostgreSQL error mesage:
> ERROR: COPY command, running in backend with effective uid 26 could not open 
> file '/home/larsf/DATA/gravtype.txt' for reading. Errno = Permission denied 
> (13)."

Are the permissions on /home/larsf and /home/larsf/DATA set to allow
user postgres to do lookups in those directories?

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Seema NoorDate: 2001-03-25 18:12:23
Subject: Problem in PostgreSQL - jdbc
Previous:From: Tom LaneDate: 2001-03-25 16:46:36
Subject: Re: how do I CHECK 'field only contains characters 0-9 or space?'

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group