From: sandhya <sandhyar@amiindia.co.in>
To: R, Rajesh \(STSD\) <rajesh.r2@hp.com>
Cc: postgre <pgsql-admin@postgresql.org>
Cc: sandhya <sandhyar@amiindia.co.in>
Subject: Re: reg:file transfer error
Date: Wed, 7 Dec 2005 15:57:48 +0530
Message-ID: <054e01c5fb18$deced150$cd00000a@amiindiahjwbgh> (raw)
References: <5CBFB210D9870F40B9E5A0FBD31F3A7702FD70A3@bgeexc01.asiapacific.cpqcorp.net>
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@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, rajesh.r2@hp.com
Subject: Re: reg:file transfer error
In-Reply-To: <054e01c5fb18$deced150$cd00000a@amiindiahjwbgh>
References: <5CBFB210D9870F40B9E5A0FBD31F3A7702FD70A3@bgeexc01.asiapacific.cpqcorp.net> <054e01c5fb18$deced150$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