Re: Help with plpython3u

From: PEDRO PABLO SEVERIN HONORATO <ppseverin(at)miuandes(dot)cl>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Help with plpython3u
Date: 2020-06-10 15:25:00
Message-ID: CAB2K=JM9ZuqQ+-Zi-M0cupR_M1OD5YzHRwT23zmgWguNFUJLMg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just to be clear those where instructions from here, correct?:

https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/language-pack-guide/12/EDB_Postgres_Language_Pack_Guide.1.08.html#

Yes. When I did that I could execute python functions and create the
extension in postgres without problem, but later I realized that doing this
will create the other problem with anaconda.

So when you did the Anaconda install:

https://docs.anaconda.com/anaconda/install/windows/

What did you check for the Advanced options in Step 8?

I left the first one unchecked and the second one checked, which is the
default settings.

El mié., 10 jun. 2020 a las 10:50, Adrian Klaver (<adrian(dot)klaver(at)aklaver(dot)com>)
escribió:

> On 6/10/20 7:39 AM, PEDRO PABLO SEVERIN HONORATO wrote:
> > Thank you Adrian, will see the link you sent me.
> >
> > Thank you, Laurenz. I noticed that copying the DLL is not a good idea.
> > How can I set a python path for postgres, so that I tell postgres "hey,
> > if you are looking for python see this path" and don't lose conda?
> > Because after following all Adrian's instructions and after creating
> > the variable"*PYTHONHOME = C:\edb\languagepack\v1\Python-3.7*" and
>
> Just to be clear those where instructions from here, correct?:
>
>
> https://www.enterprisedb.com/edb-docs/d/edb-postgres-advanced-server/user-guides/language-pack-guide/12/EDB_Postgres_Language_Pack_Guide.1.08.html#
>
> > adding *%PYTHONHOME%* to the *PATH, *I get this message when I open
> > Anaconda Prompt:
> > *"File "C:\Users\developer\Anaconda3\Scripts\conda-script.py", line 11,
> > in <module> from conda.cli import main ModuleNotFoundError: No module
> > named 'conda'"*
>
> So when you did the Anaconda install:
>
> https://docs.anaconda.com/anaconda/install/windows/
>
> What did you check for the Advanced options in Step 8?
>
> > *
> > *
> > Then, I removed the variable name PYTHONHOME and tried to execute again
> > Anaconda Prompt without any problem. So I think that postgres and conda
> > are like "fighting" for the PYTHONHOME variable name? Is this correct?
> >
> > El mié., 10 jun. 2020 a las 10:08, Adrian Klaver
> > (<adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>)
> escribió:
> >
> > On 6/9/20 10:38 PM, PEDRO PABLO SEVERIN HONORATO wrote:
> > > 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?
> >
> > See below for more information:
> >
> >
> https://docs.anaconda.com/anaconda/user-guide/faq/#installing-anaconda
> > >
> > > Thanks,
> > > PS
> > >
> > >
> >
> >
> > --
> > 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
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-06-10 16:17:43 Re: Help with plpython3u
Previous Message Adrian Klaver 2020-06-10 14:50:08 Re: Help with plpython3u