Received: from mail_dns.lagoon.nc (mail.offratel.nc [209.58.55.28]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA36035; Tue, 14 Sep 1999 14:16:07 -0400 (EDT) (envelope-from fillons@offratel.nc) Received: from portable (unverified [209.58.55.166]) by mail_dns.lagoon.nc (Rockliffe SMTPRA 3.4.3) with SMTP id ; Wed, 15 Sep 1999 05:16:57 +1100 Message-ID: <000e01befedd$3e2210c0$a6373ad1@portable> From: "=?iso-8859-1?Q?St=E9phane_FILLON?=" To: "pgsql-sql" , "pgsql-hackers" , "pgsql-general" Subject: Permission problem with COPY FROM Date: Wed, 15 Sep 1999 03:50:09 +1100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0004_01BEFF2D.684ADB20" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 This is a multi-part message in MIME format. ------=_NextPart_000_0004_01BEFF2D.684ADB20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_0004_01BEFF2D.684ADB20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi,
 
Each time I try to insert an ascii = file with the=20 COPY FROM command, I get the following message:
 
 "ERROR: COPY command, = running in=20 backend with effective uid 501 (that's Postgres), could not open file=20 '/usr/local/.../cltclr001' for reading. Error: Permission not allowed=20 (13)."
 
What rights do I have to put to = process the COPY=20 command inside PSQL.
 
I have try nearly everything, actual = rights:=20 uog+rw even on the directory.
 
 
What's wrong.
 
Stephane FILLON
------=_NextPart_000_0004_01BEFF2D.684ADB20--