Re: Problem with pl/python procedure connecting to the internet - Mailing list pgsql-general

From Igor Sosa Mayor
Subject Re: Problem with pl/python procedure connecting to the internet
Date
Msg-id 878u93ei4e.fsf@gmail.com
Whole thread Raw
In response to Problem with pl/python procedure connecting to the internet  (Igor Sosa Mayor <joseleopoldo1792@gmail.com>)
List pgsql-general
John R Pierce <pierce@hogranch.com> writes:

> On 8/22/2015 12:23 AM, Igor Sosa Mayor wrote:
>> Somehow I have the impression postgres is trying to make a connection
>> without having to rights to get the answer (I'm on linux). I dont
>> understand exactly which process (and with which rights) is executing
>> the plpython procedure...
>>
>> Thanks in any case for your answer.
>
> each client connection creates a postgresql server process.
> pl-anything runs in that context, along with all sql for that client.
>
>
> say...   is by any chance selinux running in enforcing mode ?  you
> might try temporarily setting it to 'permissive' with the setenforce
> command, and see if your python works.

thanks. No selinux is running.

Is there a way to check whether a process has the rights to make a
connection to the internet (TCP or something like that)?

pgsql-general by date:

Previous
From: Chris Mair
Date:
Subject: Re: master/master replication with load balancer in front
Next
From: Adrian Klaver
Date:
Subject: Re: Problem with pl/python procedure connecting to the internet