Re: Help with plpython3u

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?

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?

Thank you so much for your help!! :D
PS

El mar., 9 jun. 2020 a las 20:37, Adrian Klaver (<adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> >
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>