Re: Help with plpython3u

[PEDRO PABLO SEVERIN HONORATO <ppseverin@xxxxxxxxxxx>]

something like EDB_PYTHONHOME
that only the Postgres install would use.  

That's exactly what I was looking for. Isn't a way to configure some postgres file, so that postgres would use that file and look for python in that directory before seeing the path?

I guess you have to ask questions on Stackoverflow 

Stackoverflow was the first place where I asked this, but with less knowledge than now. Maybe now I can ask a more concrete question about paths.

Anyways, thank you very much for your time, Adrian. I really appreciate it. If I manage to solve this I'll let you know, so if anyone else has the same problem.

El mié., 10 jun. 2020 a las 18:19, Adrian Klaver (<adrian.klaver@xxxxxxxxxxx>) escribió:

On 6/10/20 10:39 AM, PEDRO PABLO SEVERIN HONORATO wrote:
> I'm sorry, when I try to create a plpython3u function, the database
> tells me:
>
> "*ERROR: could not load library "C:/Program
> Files/PostgreSQL/12/lib/plpython3.dll": The specified module could not
> be found. SQL state: 58P01*"
>
> If I try to execute the function, then the database crashes.
>

Alright that was not fun. I pulled up an Windows 7 machine and installed
Anaconda and Postgres from EDB. I installed Anaconda with the defaults
you mentioned. I could not get Anaconda and Postgres to work together
with regards to Python. As you have found the PYTHONHOME setting
Postgres needs is picked up by Anaconda and prevents it from starting.
Dropping PYTHONHOME  allows Anaconda to work but causes plpython3u to
fail. To me the solution would be to have something like EDB_PYTHONHOME
that only the Postgres install would use. I could not find anything like
that though. I'm out of ideas. I now remember why I don't use Windows:(
I was going to point you at the EDB forums, but they don't exist
anymore. I guess you have to ask questions on Stackoverflow:

https://stackoverflow.com/questions/tagged/enterprisedb

I would try there.


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx