Re: Help with plpython3u

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(dot)klaver(at)aklaver(dot)com <mailto: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>
> <mailto: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>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
> >
>
>
> --
> 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