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.
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@aklaver.com