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 B2BDC9DCB56 for ; Wed, 7 Dec 2005 06:21:18 -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 97715-05 for ; Wed, 7 Dec 2005 06:21:20 -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 DDFBE9DCD03 for ; Wed, 7 Dec 2005 06:21:15 -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 jB7ARXrR025420; Wed, 7 Dec 2005 15:57:34 +0530 Message-ID: <054e01c5fb18$deced150$cd00000a@amiindiahjwbgh> From: "sandhya" To: "R, Rajesh \(STSD\)" Cc: "postgre" , "sandhya" References: <5CBFB210D9870F40B9E5A0FBD31F3A7702FD70A3@bgeexc01.asiapacific.cpqcorp.net> Subject: Re: reg:file transfer error Date: Wed, 7 Dec 2005 15:57:48 +0530 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_054B_01C5FB46.F8591F80" 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/48 X-Sequence-Number: 19768 This is a multi-part message in MIME format. ------=_NextPart_000_054B_01C5FB46.F8591F80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Initially it worked fine for tmp....directory. when i changed it to... psql "dbname" -U root from that time onwards it is not accepting even /tmp Where to change for these permissions.Pls explain me what to do..I just = started working on Linux.... Thanks, Sandhya ----- 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_054B_01C5FB46.F8591F80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Initially it worked fine for=20 tmp....directory.
when i changed it to...
psql "dbname" -U root
 
from that time onwards it is not = accepting even=20 /tmp
Where to change for these = permissions.Pls explain=20 me what to do..I just started working on Linux....
 
Thanks,
Sandhya
 
 
 
----- 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_054B_01C5FB46.F8591F80--