Permission problem using lo_export

From: pascalvdg <pascalvdg(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Permission problem using lo_export
Date: 2007-03-05 12:47:32
Message-ID: 9310861.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

We are running a web application based on ColdFusion 7 and PostgreSQL 8 on 2
Windows 2003 servers.
On server 1 (ColdFusion side) a query uses the lo_export function to get a
blob out of the database on server 2. This blob must be written to disk but
since the postgres user is only known on server 2, we cannot grant that user
write access on server 1.

Does anybody has experience with this? I guess it's more Windows 2003
related but anyway...

Thanks in advance.

Pascal
--
View this message in context: http://www.nabble.com/Permission-problem-using-lo_export-tf3348649.html#a9310861
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Browse pgsql-general by date

  From Date Subject
Next Message Ares 2007-03-05 12:59:59 Re: Having performance problems with TSearch2
Previous Message Bruce McAlister 2007-03-05 12:33:18 PostgreSQL 8.2.3 VACUUM Timings/Performance