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-25 08:30:11
Message-ID: 87a8tf4vos.fsf@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Igor Sosa Mayor <joseleopoldo1792(at)gmail(dot)com> writes:

> Igor Sosa Mayor <joseleopoldo1792(at)gmail(dot)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!

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Sosa Mayor 2015-08-25 08:31:12 Re: Problem with pl/python procedure connecting to the internet
Previous Message Karsten Hilbert 2015-08-25 07:04:08 Re: PostgreSQL Developer Best Practices