SEO

#1 (**permalink**) 04-10-2008, 05:33 AM

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

#2 (**permalink**) 04-10-2008, 05:33 AM

"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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

reg:file transfer error