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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>) 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
<mailto:adrian.klaver@xxxxxxxxxxx
<mailto:adrian.klaver@xxxxxxxxxxx>>>) 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@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
<mailto:adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>>
>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx <mailto:adrian.klaver@xxxxxxxxxxx>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
