Re: How to stop script executions

From: Dev Kumkar <devdas(dot)kumkar(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to stop script executions
Date: 2016-07-26 13:19:12
Message-ID: CALSLE1Pwjh0N_1o9gwocpkZs0v1+v+1p_-mBd4Pu8UuCYsXzWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jul 26, 2016 at 6:35 PM, David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> The way to go about prohibiting their usage altogether is specific to your
> installation method. But by default those languages are not installed into
> newly created databases and only a superuser can "CREATE EXTENSION" so
> without superuser intervention uses in the database will be unable to
> create functions in those languages. If that is an insufficient level of
> prevention you would have to somehow get your installation of PostgreSQL to
> not include those core extensions. I'm pretty sure that during compilation
> you ​can do this. For packaged distributions I do not know what all is
> involved (i.e., what you have to choose to not install).
>
>
>
Thanks David !
Yeah, the extensions for perl and python are not installed. Checked both
pg_available_extensions & \dx output.

Can I run OS commands without these extensions?

Regards...

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dev Kumkar 2016-07-26 13:20:40 Re: How to stop script executions
Previous Message Alex Ignatov 2016-07-26 13:16:26 Re: How to stop script executions