Re: Help with plpython3u

Thank you, Adrian. Will read about all this. By the way, the issue
reappeared. For some reason, I had to reinstall Anaconda and had to delete
the "PYTHONHOME" variable because I could not launch conda.
Seems that they both fight for the same variable name?
Is there a way to set it to two different names?

Thanks,
PS

El mar., 9 jun. 2020 a las 22:16, Adrian Klaver (<adrian(dot)klaver(at)aklaver(dot)com>)
escribió:

> 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
>