From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | PEDRO PABLO SEVERIN HONORATO <ppseverin(at)miuandes(dot)cl> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Help with plpython3u |
Date: | 2020-06-10 17:44:31 |
Message-ID: | d52ae57f-3da8-1f39-8cd3-09c1dcb2b908@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 I'm going to have to review where we are at. That will not
happen for a bit, so hang on.
>
> El mié., 10 jun. 2020 a las 13:36, PEDRO PABLO SEVERIN HONORATO
> (<ppseverin(at)miuandes(dot)cl <mailto:ppseverin(at)miuandes(dot)cl>>) escribió:
>
> I just think it would make your life easier to reduce the number of
> Python installs you have. If I'm keeping track correctly you now have:
>
> 1) Anaconda Python
>
> 2) OS system Python
>
> 3) EDB Python.
>
> The OS is windows, and afaik python is not included in windows, so
> it would be just Anaconda python and EDB python.
>
> What happens if you try to create a plpythonu3u function in the
> database?
>
> The database crashes and tells me "*Connection to the server has
> been lost.*"
>
> El mié., 10 jun. 2020 a las 13:12, Adrian Klaver
> (<adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>>)
> escribió:
>
> On 6/10/20 9:57 AM, PEDRO PABLO SEVERIN HONORATO wrote:
> > Alright. Before we go any further it would be best to
> determine what
> > your needs are. So:
> >
> > 1) Did you install Anaconda just to get Python or for the
> science data
> > set of libraries it provides?
> >
> > A: For the data science set of libraries. Also, it helps to keep
> > libraries updated.
> >
> > 2) Do you need the system Python you installed for anything that
> > Anaconda does not provide?
> >
> > A: I don't know if I understood well this question, but I
> think the
> > answer is no. Anaconda does provide almost all the libraries
> I need. I
> > just installed a couple more (like talib, tensorflow, keras,
> psycopg2,
> > etc) and created some libraries of my own.
>
> Those libraries are available from Anaconda:
>
> https://docs.anaconda.com/anaconda/packages/py3.7_win-64/
>
> or from AnacondaCloud:
>
> https://anaconda.org/
>
> I just think it would make your life easier to reduce the number of
> Python installs you have. If I'm keeping track correctly you now
> have:
>
> 1) Anaconda Python
>
> 2) OS system Python
>
> 3) EDB Python.
>
>
> What happens if you try to create a plpythonu3u function in the
> database?
>
>
> >
> > 3) What are you planning to do with plpython3u?
> >
> > A: I'm planning to create some functions using python
> language to
> > process data that is stored in real time in the database and
> then use
> > them as triggers. I would like to be able to import some
> libraries that
> > I have in python to do it. Some of the functions are fourier
> and wavelet
> > transforms. If I can't import the library, then I'll have to
> code the
> > full function, but it's easier (for me) to code them in
> python language
> > rather than sql language.
> >
> > El mié., 10 jun. 2020 a las 12:17, Adrian Klaver
> > (<adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>>) escribió:
> >
> > On 6/10/20 8:25 AM, PEDRO PABLO SEVERIN HONORATO wrote:
> > > 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.
> > >
> >
> > Alright. Before we go any further it would be best to
> determine what
> > your needs are. So:
> >
> > 1) Did you install Anaconda just to get Python or for the
> science data
> > set of libraries it provides?
> >
> > 2) Do you need the system Python you installed for
> anything that
> > Anaconda does not provide?
> >
> > 3) What are you planning to do with plpython3u?
> >
> >
> > --
> > Adrian Klaver
> > adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
> <mailto:adrian(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)com>>
> >
>
>
> --
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2020-06-10 22:19:32 | Re: Help with plpython3u |
Previous Message | PEDRO PABLO SEVERIN HONORATO | 2020-06-10 17:39:21 | Re: Help with plpython3u |