Received: from gyw.com (gyw.com [209.55.67.177]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f56ESfE57110 for ; Wed, 6 Jun 2001 10:28:41 -0400 (EDT) (envelope-from tjk@tksoft.com) Received: from smtp3.tksoft.com (smtp3.tksoft.com [192.168.50.56] (may be forged)) by gyw.com (8.8.8/8.8.8) with ESMTP id GAA11237; Wed, 6 Jun 2001 06:30:52 -0700 Received: (from tjk@tksoft.com) by smtp3.tksoft.com (8.8.8/8.8.8) id GAA19076; Wed, 6 Jun 2001 06:04:33 -0700 From: "tjk@tksoft.com" Message-Id: <200106061304.GAA19076@smtp3.tksoft.com> Subject: Re: Large Objects - lo_export To: pnguruji@yahoo.com (Guru Prasad) Date: Wed, 6 Jun 2001 06:04:32 -0700 (PDT) Cc: pgsql-sql@postgresql.org In-Reply-To: from "Guru Prasad" at Jun 06, 2001 06:52:31 PM X-Info: None MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/61 X-Sequence-Number: 3274 You must be logged in as the unix user postgres. (Presuming /home/postgres/ is writable by postgres and the file doesn't exist.) Try doing touch /home/postgres/junk.tgz from the command line. It should also fail. Troy > > > Hi to list ! > > while running psql as 'postgres' user, i executed the following query. > > 'select lo_export(img.image, '/home/postgres/junk.tgz') from img where > data = 'tar file'; > > The result of the above command is as follows. > > ERROR: lo_export: can't open unix file > "/home/postgres/junk.tgz": Permission denied > > i performed the above query as superuser ('postgres'). I hope it' having > all the superuser previleges. > > I am not sure why i am getting the above error. > > Any one got any clue for it. > thanx in advance. > > guru. > bk SYSTEMS (P) Ltd. > P . N . G U R U P R A S A D > ------------------------------------------------------------------------------- > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >