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 87a8tic54h.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
s d <daku.sandor@gmail.com> writes:

> It might be a dumb thought, but...

thanks. There are not dumb thoughts with such problems...

> Did you run the script from ipython as postgres user?
> External programs called by triggers run as postgres, and maybe your
> postgres user doesn't have rights to reach the remote service.

i don't understand exactly (it is the 1. time I write a procedure even
in PG). It is so:
1. I run ipython as my user (igor);
2. I run postgres both as user and as postgres. In both cases the same
   error. PG does not run ipython, because ipython is just a console for
   python. PG should only run python (2 or 3).

IN any case, important is your last thought... I dont see in the doc of
PG in the chapter of rules and privileges nothing about privileges to
make internet connections...



--
:: Igor Sosa Mayor     :: joseleopoldo1792@gmail.com ::
:: GnuPG: 0x1C1E2890   :: http://www.gnupg.org/      ::
:: jabberid: rogorido  ::                            ::

pgsql-general by date:

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