Re: reg:file transfer error

----- 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: 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