Postgres Pro
Downloads
Home   >   mailing lists

Permission problem with COPY FROM - Mailing list pgsql-sql

From Stéphane FILLON
Subject Permission problem with COPY FROM
Date
Msg-id 000e01befedd$3e2210c0$a6373ad1@portable
Whole thread Raw
Responses Re: [HACKERS] Permission problem with COPY FROM  (Nuchanach Klinjun <nuchk@inet.co.th>)
List pgsql-sql
Tree view
Hi,
 
Each time I try to insert an ascii file with the COPY FROM command, I get the following message:
 
 "ERROR: COPY command, running in backend with effective uid 501 (that's Postgres), could not open file '/usr/local/.../cltclr001' for reading. Error: Permission not allowed (13)."
 
What rights do I have to put to process the COPY command inside PSQL.
 
I have try nearly everything, actual rights: uog+rw even on the directory.
 
 
What's wrong.
 
Stephane FILLON

pgsql-sql by date:

Previous
From: "Esteban Chiner Sanz"
Date:
Subject: Primary key on NUMERIC type
Next
From: Jens Glaser
Date:
Subject: reliable way to crash postgres :)