On 08/23/2015 01:15 PM, Igor Sosa Mayor wrote:
Igor Sosa Mayor <joseleopoldo1792@xxxxxxxxx> 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 want to update the situation in this email following up my own email.
Sorry for not answering every question (in any case: I don't have
SElinux or similar).
The situation is very strange. It works now perfectly BUT ONLY after
restarting PG. I'm playing with the log options in PG and I don't see in
the logs nothing strange (PG starts without problems).
As I understand it you are running everything on a laptop.
Are you saying the laptop has been running non-stop the three days this
discussion has been going on and Postgres was never shut down till now?
But I see that the log options in PG are really rich. Could maybe
someone tell me which could be the best options to find the problem? I
will be offline now during 24h, but I will try to make some experiments
in the meantime.
From here:
http://www.postgresql.org/docs/9.4/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
I would at least log:
log_connections
log_disconnections
log_statement 'mod'
log_line_prefix %u %m %p
So does looking back in the logs, either Postgres or system, show anything?
Thanks again for your help.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
