Re: ERROR: ImportError: No module named 'psutil'

2021-08-02 Thread Ganesh Korde
Ok, thanks guys. Let me check that. On Sun, Aug 1, 2021 at 10:05 PM Tom Lane wrote: > Adrian Klaver writes: > > In that vein the OP could run: > > > DO $$ > > import sys > > plpy.notice(sys.version) > > $$ LANGUAGE plpython3u; > > > in the database to see what plpython3u is actually p

Re: ERROR: ImportError: No module named 'psutil'

2021-08-01 Thread Tom Lane
Adrian Klaver writes: > In that vein the OP could run: > DO $$ > import sys > plpy.notice(sys.version) > $$ LANGUAGE plpython3u; > in the database to see what plpython3u is actually pointing at? +1 ... looking at sys.path in the same way would also be useful.

Re: ERROR: ImportError: No module named 'psutil'

2021-08-01 Thread Adrian Klaver
On 8/1/21 8:51 AM, Tom Lane wrote: Adrian Klaver writes: Now it's possible that the wording didn't change exactly at the 2/3 boundary, but I doubt it. So it looks to me like the alleged plpython3u language is actually invoking python 2.something, which is unlikely to work well at all. In

Re: ERROR: ImportError: No module named 'psutil'

2021-08-01 Thread Tom Lane
Adrian Klaver writes: > On 8/1/21 7:40 AM, Ganesh Korde wrote: >> I am trying to run a python function using the language plpython3u and >> I am getting the below error, though I have installed psutil. >> >> postgres=# select * from get_psutil_mem(); >> ERR

Re: ERROR: ImportError: No module named 'psutil'

2021-08-01 Thread Adrian Klaver
below error, though I have installed psutil. postgres=# select * from get_psutil_mem(); ERROR:  ImportError: No module named 'psutil' CONTEXT:  Traceback (most recent call last):   PL/Python function "get_psutil_mem", line 2, in     from psutil import virtual_memory, s

ERROR: ImportError: No module named 'psutil'

2021-08-01 Thread Ganesh Korde
. postgres=# select * from get_psutil_mem(); ERROR: ImportError: No module named 'psutil' CONTEXT: Traceback (most recent call last): PL/Python function "get_psutil_mem", line 2, in from psutil import virtual_memory, swap_memory PL/Python function "get_psutil_mem&q