Subject: Re: ERROR: ImportError: No module named 'psutil'
To: Ganesh Korde <ganeshakorde@gmail.com>,
 pgsql-general <pgsql-general@lists.postgresql.org>
References: 
 <CAPNyb0UKUn_RwvD+jtmo27CqPzrOa3Ae+JuzCcWwnNXvnwPMSg@mail.gmail.com>
 <CAPNyb0X=vq55ZWNuK1n+gfhPLy+J8KDn9XXcONKj30iZPYi+Kw@mail.gmail.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <113c9dee-7126-79f3-0c78-03ecbba89f0b@aklaver.com>
Date: Sun, 1 Aug 2021 08:35:39 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.12.0
MIME-Version: 1.0
In-Reply-To: 
 <CAPNyb0X=vq55ZWNuK1n+gfhPLy+J8KDn9XXcONKj30iZPYi+Kw@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/113c9dee-7126-79f3-0c78-03ecbba89f0b%40aklaver.com>
Precedence: bulk

On 8/1/21 7:40 AM, Ganesh Korde wrote:
> Hi Everyone,
> 
> Environment
> OS : Linux ubuntu 4.4.0-87-generic
> Database:  PostgreSQL 10.7 on x86_64-pc-linux-gnu,
> Extension: plpython3u
> Python version: Python 3.5.2
> 
>   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();
> ERROR:  ImportError: No module named 'psutil'
> CONTEXT:  Traceback (most recent call last):
>    PL/Python function "get_psutil_mem", line 2, in <module>
>      from psutil import virtual_memory, swap_memory
> PL/Python function "get_psutil_mem"
> 

> The above function is used by pgwatch2 to monitor memory.
> 
> *I tried installing python3.4.3 from source code but still the same 
> error.* Also tried most of the solutions provided on the internet but 
> nothing helped. Problem is with the psutil module only.
> 
> Please let me know if I am missing anything.

How did you install plpython3u?

How did you install psutil?

> 
> Any help will be much appreciated.
> 
> Regards,
> Ganesh Korde.


-- 
Adrian Klaver
adrian.klaver@aklaver.com