Re: [ADMIN] reg:file transfer error

[sandhya]

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 ----- From: R, Rajesh (STSD) To: sandhya 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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