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
>