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

From Adrian Klaver
Subject Re: Problem with pl/python procedure connecting to the internet
Date
Msg-id 55DA076C.8090105@aklaver.com
Whole thread Raw
In response to Re: Problem with pl/python procedure connecting to the internet  (Igor Sosa Mayor <joseleopoldo1792@gmail.com>)
List pgsql-general
On 08/23/2015 10:38 AM, Igor Sosa Mayor wrote:
> Adrian Klaver <adrian.klaver@aklaver.com> writes:
>
>>> I tried both... in my system (archlinux) there is plpython2u and
>>> plpythonu. I think the 2nd one is python3.
>>
>> How did they get there?
>>
>> Or more to the point how where they built?
>
> just installed with postgresql which comes with archlinux. I did not
> built anything. But, really: I dont think the problem is plpython2u o 3:
> 1. I have in my system both and both have the same libraries (in this
>     case, geopy);
> 2. other procedures with plpython (2 or 3) which DO NOT CONNECT to the
>     internet work perfectly.
>
> The problem is the connection, either the setup in my laptop or the
> setup in my network (but I get the same problem at home and at work...)

You are using the same machine, the laptop, in both locations, correct?

If so then the problem is some sort of access control issue.

When you try an INSERT, what shows in?:

1) The Postgres logs.

2) The system log.

>
>> What happens if you change your geocodificar to use plpythonu?
>
> exactly the same. I tested all combinations...
>
> (thanks again!)
>
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Igor Sosa Mayor
Date:
Subject: Re: Problem with pl/python procedure connecting to the internet
Next
From: Tom Lane
Date:
Subject: Re: Problem with pl/python procedure connecting to the internet