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 87a8tf4vos.fsf@gmail.com
Whole thread Raw
In response to Problem with pl/python procedure connecting to the internet  (Igor Sosa Mayor <joseleopoldo1792@gmail.com>)
Responses Re: Problem with pl/python procedure connecting to the internet
List pgsql-general
Igor Sosa Mayor <joseleopoldo1792@gmail.com> writes:

> Igor Sosa Mayor <joseleopoldo1792@gmail.com> writes:
>
>> My question is therefore:
>> 1. is there a way to permit the pl/python to connect to the internet all
>>    the time and with a better configuration?
>> 2. or should I forget the procedure and write a python script outside
>>    the database?

I'm again with the last update. The problem seems to be that for some
reason PG does not realize that there is a network connection.

More precisely:
1. I start the computer
2. PG starts and I can use it normally, EXCEPT from the plpython
   procedure which does not connect
3. then I restart PG (with systemd) and it works. PG seems to "see" that
   there is a connection.

Maybe it has something to do with systemd? I'm trying to get all debug
information, but I can't see anything strange in the log. In order not
to full the list with an attachment, I post the log here:
http://pastie.org/10373991

Any ideas?

Thanks in advance!

pgsql-general by date:

Previous
From: Karsten Hilbert
Date:
Subject: Re: PostgreSQL Developer Best Practices
Next
From: Igor Sosa Mayor
Date:
Subject: Re: Problem with pl/python procedure connecting to the internet