Search Postgresql Archives

Re: Access disk from plpython

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/15/2012 01:08 AM, Adrian Klaver wrote:
On 11/14/2012 09:03 AM, Jeff Janes wrote:
On Wed, Nov 14, 2012 at 8:44 AM, Rhys A.D. Stewart
<rhys.stewart@xxxxxxxxx> wrote:
Greetings all,

having a permission issue with writing a file using plpython to a local
folder, changed permissions to everyone read and write and even changed the
owner to postgres. but no joy, any suggestions?

plpython is a "trusted" langauge.  That means pgsql trusts it not to
allow you to break out of the sandbox and interact directly with the
file system or the database server internals.

If you need to do those things, you can use plpythonu.

My understanding is that of Postgres 7.4 plpython does not exist. In other words only the untrusted version is available.

... and that's because Python's design - in particular, the introspection features - means the the restricted mode wasn't particularly restricted. See http://docs.python.org/2/library/restricted.html , http://wiki.python.org/moin/SandboxedPython .
-- 
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux