From: sandhya <sandhyar@amiindia.co.in>
To: postgre <pgsql-admin@postgresql.org>
Subject: Fw: reg:file transfer error
Date: Wed, 7 Dec 2005 15:53:24 +0530
Message-ID: <053001c5fb18$41a61f00$cd00000a@amiindiahjwbgh> (raw)
I did even i am not getting...Not only tmp....in all directories i am unable to export
----- 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: sandhyar@amiindia.co.in
Subject: Re: Fw: reg:file transfer error
In-Reply-To: <053001c5fb18$41a61f00$cd00000a@amiindiahjwbgh>
References: <053001c5fb18$41a61f00$cd00000a@amiindiahjwbgh>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox