Re: Help with plpython3u - Mailing list 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@miuandes.cl <mailto:ppseverin@miuandes.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com
>         <mailto:adrian.klaver@aklaver.com>
>         <mailto:adrian.klaver@aklaver.com
>         <mailto:adrian.klaver@aklaver.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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>         <mailto:adrian.klaver@aklaver.com
>         <mailto:adrian.klaver@aklaver.com>>
>          >
> 
> 
>         -- 
>         Adrian Klaver
>         adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com