Re: reg:file transfer error

From: "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
To: "R, Rajesh \(STSD\)" <rajesh(dot)r2(at)hp(dot)com>
Cc: "postgre" <pgsql-admin(at)postgresql(dot)org>, "sandhya" <sandhyar(at)amiindia(dot)co(dot)in>
Subject: Re: reg:file transfer error
Date: 2005-12-07 10:27:48
Message-ID: 054e01c5fb18$deced150$cd00000a@amiindiahjwbgh
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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: pgsql-admin-owner(at)postgresql(dot)org [mailto:pgsql-admin-owner(at)postgresql(dot)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

Browse pgsql-admin by date

  From Date Subject
Next Message Guido Barosio 2005-12-07 11:54:13 Re: Checkpoint...
Previous Message sandhya 2005-12-07 10:23:24 Fw: reg:file transfer error