pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
reg:file transfer error
4+ messages / 2 participants
[nested] [flat]

* reg:file transfer error
@ 2005-12-07 10:04 sandhya <sandhyar@amiindia.co.in>
  2005-12-07 15:15 ` Re: reg:file transfer error Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 4+ messages in thread

From: sandhya @ 2005-12-07 10:04 UTC (permalink / raw)
  To: pgsql-admin; +Cc: sandhya <sandhyar@amiindia.co.in>

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: reg:file transfer error
  2005-12-07 10:04 reg:file transfer error sandhya <sandhyar@amiindia.co.in>
@ 2005-12-07 15:15 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 2005-12-07 15:15 UTC (permalink / raw)
  To: sandhya <sandhyar@amiindia.co.in>; +Cc: pgsql-admin

"sandhya" <sandhyar@amiindia.co.in> writes:
> ERROR:  could not create server file "/tmp/sss.txt": Permission denied

If /tmp is already mode 777, then the only reason I can think of for
this is that you've got SELinux turned on and it's configured to forbid
the postmaster from writing in /tmp.  Possibly updating your selinux-policy
package would help.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Fw: reg:file transfer error
@ 2005-12-07 10:23 sandhya <sandhyar@amiindia.co.in>
  0 siblings, 0 replies; 4+ messages in thread

From: sandhya @ 2005-12-07 10:23 UTC (permalink / raw)
  To: pgsql-admin




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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: reg:file transfer error
@ 2005-12-07 10:27 sandhya <sandhyar@amiindia.co.in>
  0 siblings, 0 replies; 4+ messages in thread

From: sandhya @ 2005-12-07 10:27 UTC (permalink / raw)
  To: R, Rajesh \(STSD\) <rajesh.r2@hp.com>; +Cc: pgsql-admin; sandhya <sandhyar@amiindia.co.in>

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-12-07 15:15 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-07 10:04 reg:file transfer error sandhya <sandhyar@amiindia.co.in>
2005-12-07 15:15 ` Tom Lane <tgl@sss.pgh.pa.us>
2005-12-07 10:23 Fw: reg:file transfer error sandhya <sandhyar@amiindia.co.in>
2005-12-07 10:27 Re: reg:file transfer error sandhya <sandhyar@amiindia.co.in>

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