lo_export -- permission denied

Поиск
Список
Период
Сортировка
Искать
От
Alexander Pucher
Тема
lo_export -- permission denied
Дата
Msg-id
3C47F99D.70009@atlas.gis.univie.ac.at
Список
Дерево обсуждения
lo_export -- permission denied Alexander Pucher <pucher@atlas.gis.univie.ac.at>
Re: lo_export -- permission denied Tom Lane <tgl@sss.pgh.pa.us>
Hi,

i followed this 
(http://designmagick.50megs.com/postgresql-tutorial/file.html) tutorial 
to import/export files to/from PostgreSQL. It all works fine on my 
Notebook, but when I try to put it on another machine, 

"select lo_export(OID,'path/on/local/disc')"

comes up with an error:

Warning : PostgreSQL query failed: ERROR: lo_export: can't open unix 
file "/path/to/local/disc/filename": Permission denied in 
/path/to/php_files/file_retrieve.php on line 64

It works fine when I change the local output path to /tmp, but it fails 
when the path is under the webserver root. I checked/compared all 
file/diretory permissions on both machines, they're all the same.

Any suggestions ?

Regards
ALEX

-- 
________________________________________________________

Institut fuer Geographie und Regionalforschung
Universität Wien
Kartografie und Geoinformation

Departement of Geography and Regional Research
University of Vienna
Cartographie and GIS

Universitaetstr. 7, A-1010 Wien, AUSTRIA

Tel: (+43 1) 4277 48644
Fax: (+43 1) 4277 48649
E-mail: pucher@atlas.gis.univie.ac.at

FTP: ftp://ftp.gis.univie.ac.at
WWW: http://www.gis.univie.ac.at/karto
________________________________________________________

"He that will not apply new remedies must expect new evils; for time is the greatest innovator"--Francis Bacon

             


В списке pgsql-general по дате отправления
От: Vince Vielhaber
Дата:
Сообщение: Re: Books on PostgreSQL
От: Esger Abbink
Дата:
Сообщение: Re: Books on PostgreSQL
FAQ