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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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