X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id A71C29DD06A for ; Wed, 7 Dec 2005 06:16:47 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 88805-08 for ; Wed, 7 Dec 2005 06:16:49 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mars.amiindia.co.in (unknown [203.199.198.229]) by postgresql.org (Postfix) with ESMTP id BBD089DCD81 for ; Wed, 7 Dec 2005 06:16:42 -0400 (AST) Received: from amiindiahjwbgh ([10.0.0.205]) (authenticated bits=0) by mars.amiindia.co.in (8.12.11/8.12.11) with ESMTP id jB7AN9XU025175 for ; Wed, 7 Dec 2005 15:53:10 +0530 Message-ID: <053001c5fb18$41a61f00$cd00000a@amiindiahjwbgh> From: "sandhya" To: "postgre" Subject: Fw: reg:file transfer error Date: Wed, 7 Dec 2005 15:53:24 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_052D_01C5FB46.5B3CA230" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.001 required=5 tests=[HTML_MESSAGE=0.001] X-Spam-Score: 0.001 X-Spam-Level: X-Archive-Number: 200512/47 X-Sequence-Number: 19767 This is a multi-part message in MIME format. ------=_NextPart_000_052D_01C5FB46.5B3CA230 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I did even i am not getting...Not only tmp....in all directories i am = unable to export ----- Original Message -----=20 From: R, Rajesh (STSD)=20 To: sandhya=20 Sent: Wednesday, December 07, 2005 3:37 PM Subject: RE: [ADMIN] reg:file transfer error Try setting write perm. in /tmp ..(chmod 777 /tmp). 'postgres' user needs to do the write. -- Rajesh R =20 -------------------------------------------------------------------------= ----- From: pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of sandhya Sent: Wednesday, December 07, 2005 3:35 PM To: postgre Cc: sandhya Subject: [ADMIN] reg:file transfer error hi.... when i am using select lo_export(filemanip.objid,'/tmp/sss.txt') from = filemanip where fname =3D '/usr/sample.txt' ERROR: could not create server file "/tmp/sss.txt": Permission denied please tell me what may be the problem.Any permissions i have to = change? Where to modify inorder to perform successful operation. I am in root permission only.....Though it is not working. Pls tell me what to do as early as possible....I need it urgently.. Thanks&Regards Sandhya ------=_NextPart_000_052D_01C5FB46.5B3CA230 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
 

I did even i am not getting...Not only = tmp....in=20 all directories i am unable to export
----- Original Message -----
From:=20 R, Rajesh = (STSD)=20
To: sandhya
Sent: Wednesday, December 07, = 2005 3:37=20 PM
Subject: RE: [ADMIN] reg:file = transfer=20 error

Try setting write perm. in /tmp ..(chmod 777=20 /tmp).
'postgres' user needs to do the=20 write.
 
--
Rajesh=20 R
 

From: pgsql-admin-owner@postgr= esql.org=20 [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of=20 sandhya
Sent: Wednesday, December 07, 2005 3:35 = PM
To:=20 postgre
Cc: sandhya
Subject: [ADMIN] reg:file = transfer=20 error

hi....
 
 when i am using select=20 lo_export(filemanip.objid,'/tmp/sss.txt') from filemanip=20 where fname =3D '/usr/sample.txt'

ERROR:  could not create = server file=20 "/tmp/sss.txt": Permission denied
please tell me what = may be the=20 problem.Any permissions i have to change?
Where to modify = inorder to=20 perform successful operation.
I am in root = permission=20 only.....Though it is not working.
 
Pls tell me what to do as early as possible....I need it = urgently..
 
Thanks&Regards
Sandhya
 
------=_NextPart_000_052D_01C5FB46.5B3CA230--