Re: import/export of large objects on server-side - Mailing list pgsql-hackers

From Klaus Reger
Subject Re: import/export of large objects on server-side
Date
Msg-id 64124.193.158.34.193.1004694011.squirrel@emailbox24.de
Whole thread Raw
In response to Re: import/export of large objects on server-side  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Klaus Reger <K.Reger@twc.de> writes:
>> at the moment import/export of large objects on server-side only can
>> be  activated for all users by editing config.h due to security
>> reasons. My idea is, to enable in for everyone, when using s apecial
>> directory (e.g.  /tmp). What do you think about this?
>
> It'd still be a security hole, and not significantly smaller (consider
> symlinks).
>
> Use the client-side LO import/export functions, instead.

ok, i've read the config.h and the sources. I agree that this can be a
security hole. But for our application we need lo-access from
PL/PGSQL-Procedures (explicitly on the server). We have to check out
documents, work with them and then check the next version in.

Whats about an configuration-file entry, in the matter
LO_DIR=/directory or none (which is the default).
For our product we want to be compatible with the original sources of Pg,
avoiding own patches in every new version.

What do you think about this idea? Do you have any other suggestions for
serverside lo-ing, without granting every user superuser-privileges?

Regards, Klaus







pgsql-hackers by date:

Previous
From: "Dave Cramer"
Date:
Subject: Licensing issues including another projects source code into the jdbc driver
Next
From: darcy@druid.net (D'Arcy J.M. Cain)
Date:
Subject: Re: Beta going well