pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedplr installation
2+ messages / 2 participants
[nested] [flat]
* plr installation
@ 2012-12-30 01:37 Viktor Bojović <viktor.bojovic@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Viktor Bojović @ 2012-12-30 01:37 UTC (permalink / raw)
To: pgsql-admin
Hi,
im trying to install PL/R into postgresql, but im unable create function as
normal user because the language is not trusted.
Is it possible to install plr as a trusted language instead of giving user
superuser rights?
The message i get is this:
ERROR: permission denied for language plr
Here are pg_laguage records:
bioinf=> SELECT * from pg_language;
lanname | lanowner | lanispl | lanpltrusted | lanplcallfoid | lanvalidator
| lanacl
----------+----------+---------+--------------+---------------+--------------+--------
internal | 10 | f | f | 0 | 2246 |
c | 10 | f | f | 0 | 2247 |
sql | 10 | f | t | 0 | 2248 |
plperl | 10 | t | t | 3709344925 | 3709344926 |
plpgsql | 10 | t | t | 3709344928 | 3709344929 |
*plr | 10 | t | f | 3313675089 | 0 |*
(6 rows)
if i try to update lanpltrusted field in that table, can that produce some
damage on database?
update pg_language set lanpltrusted=not( lanpltrusted ) where lanname='plr';
thanks in advance
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: plr installation
@ 2012-12-30 02:19 Joe Conway <mail@joeconway.com>
parent: Viktor Bojović <viktor.bojovic@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Joe Conway @ 2012-12-30 02:19 UTC (permalink / raw)
To: Viktor Bojović <viktor.bojovic@gmail.com>; +Cc: pgsql-admin
On 12/29/2012 05:37 PM, Viktor Bojović wrote:
> Hi,
>
> im trying to install PL/R into postgresql, but im unable create function
> as normal user because the language is not trusted.
> Is it possible to install plr as a trusted language instead of giving
> user superuser rights?
No. PL/R is untrusted because R gives access to system commands and the
file system. No way around it at the moment, nor in the foreseeable future.
Joe
--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2012-12-30 02:19 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-12-30 01:37 plr installation Viktor Bojović <viktor.bojovic@gmail.com>
2012-12-30 02:19 ` Joe Conway <mail@joeconway.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox