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.kla...@aklaver.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.kla...@aklaver.com <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > <mailto:adrian.kla...@aklaver.com > > <mailto:adrian.kla...@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.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > <mailto:adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com > >> > > > > > > > > > -- > > Adrian Klaver > > adrian.kla...@aklaver.com <mailto:adrian.kla...@aklaver.com> > > > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
