Postgres Pro
Downloads
Home   >   mailing lists

Thread: reg:file transfer error

reg:file transfer error

From
"sandhya"
Date:
hi....
 
 when i am using select lo_export(filemanip.objid,'/tmp/sss.txt') from filemanip where fname = '/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
 

Re: reg:file transfer error

From
"sandhya"
Date:
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 -----
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
 
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 = '/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
 

Re: reg:file transfer error

From
Tom Lane
Date:
"sandhya" <sandhyar@amiindia.co.in> writes:
> ERROR:  could not create server file "/tmp/sss.txt": Permission denied

If /tmp is already mode 777, then the only reason I can think of for
this is that you've got SELinux turned on and it's configured to forbid
the postmaster from writing in /tmp.  Possibly updating your selinux-policy
package would help.

            regards, tom lane