Re: Help with plpython3u - Mailing list pgsql-general

On 6/9/20 6:17 PM, PEDRO PABLO SEVERIN HONORATO wrote:
> Thanks Adrian, this actually helped me. I was looking for the "language 
> pack" thing without any success and thanks god that you pointed me in 
> the right direction :)
> 
> What I don't understand is the following. After installing the language 
> pack with stack builder, added a variable named "PYTHONHOME" with its 
> path (C:\edb\languagepack\v1\Python-3.7) and then added PYTHONHOME and 
> the full path to the PATH variable. After that, I restarted the server 
> as requested but nothing happened. Then I added "%" to the beginning and 
> the end of PYTHONHOME and C:\edb\languagepack\v1\Python-3.7, restarted 
> the server and then it worked. Why is that?

For explanation see here:

https://docs.python.org/3.7/using/windows.html
3.6.1. Excursus: Setting environment variables

> 
> Also, I would like to know if it is possible to import specific python 
> libraries? For example, I would like to use the talib library, which can 
> be downloaded and installed. Or a custom library made by myself. And how 
> can I import other python libraries, like scikit learn? Where can I find 
> information about this?

Yes you can import libraries/packages. The issue is where you are 
installing them, in the system or the Anaconda environment. I don't work 
with Windows much anymore, so I am not up on how to grab a library from 
within an Anaconda environment. Maybe someone else can help or you might 
ask the Anaconda forum:

https://groups.google.com/a/anaconda.com/forum/#!forum/anaconda

> 
> Thank you so much for your help!! :D
> PS
> 
> El mar., 9 jun. 2020 a las 20:37, Adrian Klaver 
> (<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>) escribió:
> 
>     On 6/9/20 5:26 PM, PEDRO PABLO SEVERIN HONORATO wrote:
>      > Hi Adrian,
>      >
>      > I installed Postgres downloading the file
>     posgresql-12.2-1-windows-x64
>      > from the website https://www.postgresql.org/download/windows/.
> 
>     Did you go through the steps here?:
> 
>     https://www.enterprisedb.com/edb-docs/d/postgresql/user-guides/language-pack-guide/12/toc.html
> 
>      >
>      > The python37.dll I copied to the System32 folder was located
>      > in C:\Users\developer\Anaconda3.
>      > After trying this, I installed python 3.7.0 and copied the
>     python37.dll
>      > that comes with the installation, but got the same result.
>      >
>      > Thanks,
>      > PS
>      >
>      > El mar., 9 jun. 2020 a las 20:17, Adrian Klaver
>      > (<adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>     <mailto:adrian.klaver@aklaver.com
>     <mailto:adrian.klaver@aklaver.com>>>) escribió:
>      >
>      >     On 6/9/20 5:09 PM, PEDRO PABLO SEVERIN HONORATO wrote:
>      >      > Hello!
>      >      >
>      >      > I'm cracking my head while trying to make python language work
>      >     within
>      >      > postges. I executed "*create extension plpython3u*" but I get
>      >     this error:
>      >      >
>      >      > "*ERROR: could not load library "C:/Program
>      >      > Files/PostgreSQL/12/lib/plpython3.dll": The specified module
>      >     could not
>      >      > be found. SQL state: 58P01*"
>      >      >
>      >      > Looking into several stackoverflow pages and asking like
>      >     everywhere, I
>      >      > also installed dependency walker and saw that python37.dll was
>      >     required.
>      >      > My PC already has python 3.7.4, but I don't know if that is an
>      >     issue and
>      >      > postgres requires python 3.7.0 strictly.
>      >      >
>      >      > I also copied the python37.dll file directly in the System32
>      >     folder, as
>      >      > some pages suggested. That actually made it possible to
>     run the
>      >      > "* create extension plpython3u* ", but when I try to
>     create a simple
>      >      > function like:
>      >      >
>      >      > "*CREATE FUNCTION pymax (a integer, b integer)*
>      >      > *  RETURNS integer
>      >      > AS $$
>      >      >    if a > b:
>      >      >      return a
>      >      >    return b
>      >      > *
>      >      > *$$ LANGUAGE plpython3u*;"
>      >      >
>      >      > The server crashes and I get this message: "*Connection to the
>      >     server
>      >      > has been lost*."
>      >      >
>      >      > Some additional information:
>      >      > - My PC is running windows server 2019 64 bits (its a vps)
>      >
>      >     How did you install Postgres?
>      >
>      >      > - The python version I have is 3.7.4. Installed it with
>     Anaconda
>      >
>      >     Unless things have changed since the last time I used
>     Anaconda, it
>      >     basically creates virtualenvs for it's installs. So when you
>     refer to
>      >     the Python dll above are you talking about a system installed
>     one or
>      >     one
>      >     from within the Anaconda environment?
>      >
>      >      > - Postgres version is 12.2-1. pgAdmin is 4.18
>      >      >
>      >      > Please, help me :(
>      >      > Regards,
>      >      > PS
>      >
>      >
>      >     --
>      >     Adrian Klaver
>      > adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>     <mailto:adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>>
>      >
> 
> 
>     -- 
>     Adrian Klaver
>     adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com