| From: | Stéphane FILLON <fillons(at)offratel(dot)nc> |
|---|---|
| To: | "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>, "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Permission problem with COPY FROM |
| Date: | 1999-09-14 16:50:09 |
| Message-ID: | 000e01befedd$3e2210c0$a6373ad1@portable |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stéphane FILLON | 1999-09-14 18:14:15 | BUG with UNIQUE clause |
| Previous Message | Hitesh Patel | 1999-09-14 16:31:35 | max() question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Theo Kramer | 1999-09-14 17:08:51 | Re: [HACKERS] ISO dates with European Format |
| Previous Message | Bernard Frankpitt | 1999-09-14 15:47:14 | Re: [HACKERS] Patch for user-defined C-language functions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Esteban Chiner Sanz | 1999-09-14 17:14:22 | Primary key on NUMERIC type |
| Previous Message | Tom Lane | 1999-09-14 15:45:54 | Re: [SQL] Array Madness |