Re: Problem with pl/python procedure connecting to the internet

From: Igor Sosa Mayor <joseleopoldo1792(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with pl/python procedure connecting to the internet
Date: 2015-08-22 10:24:01
Message-ID: 878u93ei4e.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John R Pierce <pierce(at)hogranch(dot)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)?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rich Schaaf 2015-08-22 11:28:55 Re: Problem with database connections timing out for long-running queries
Previous Message Chris Mair 2015-08-22 10:05:46 Re: master/master replication with load balancer in front