Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] What is unsecure postgres languages? How to disable them? - Mailing list pgsql-novice

From dipti shah
Subject Re: [GENERAL] What is unsecure postgres languages? How to disable them?
Date
Msg-id d5b05a951002220934x3e352c8em7c84334e4710826a@mail.gmail.com
Whole thread Raw
In response to What is unsecure postgres languages? How to disable them?  (dipti shah <shahdipti1980@gmail.com>)
List pgsql-novice
Tree view
Sorry Albe for confusion. Yes, I meant untrusted languages like C, PL/PerlU, PL/PythonU etc...

Thanks a lot you and Tino for nice reply. Could you guys tell me how could I verify whether those languages are installed on my PostGreSQL server?

Thanks for being there,
Dipti

On Mon, Feb 22, 2010 at 8:14 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
dipti shah wrote:
> Could anyone please tell me what is unsecure postgres
> languages(like C, pgperl, pgpython??). How to disable them or
> restrict them only for super user?

I have never heard of "unsecure" languages - what exactly do you mean?

If you mean "untrusted" languages like PL/PerlU, they are not
installed by default *and* they are restricted to superusers.

You cannot disable C functions, but to define them you must also
have superuser privileges.

Yours,
Laurenz Albe

pgsql-novice by date:

Previous
From: Marco Maggi
Date:
Subject: Re: which mailing list for bindings writers
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] SET Role doesn't work from Security Definer Function...