Install numpy to use within plpython3u in postgres 9.6 for Windows 2012 (64 bit)

[PeterS]

I am trying to install numpy to use within plpython3u in postgres 9.6 for
Windows 2012 (64 bit) but I run into dependency problems.

1) I have installed Postgres 9.6 from EnterpriseDB and the language pack,
which installs Python 3.3.  <- is there a way to install a newer version of
Python?

I have done CREATE EXTENSION plpython3u; and it works correctly.

I tried to install python modules with:   pip3.exe install numpy   and
python -m pip install --user numpy   but numpy-1.12.1 returns an error:
raise RuntimeError("Python version 2.7 or >= 3.4 required.")

If I try to install an older version of numpy==1.10.4, there are a number
of errors about blas and atlas and fortran compilers not being available -
so I didn't pursue that avenue much further.

2) If I install Python 3.6 separately, when CREATing EXTENSION plpython3u,
I get the ERROR:  could not load library "C:/Program
Files/PostgreSQL/9.6/lib/plpython3.dll": The specified module could not be
found.
The DLL *is* in that location, but the utility "depends" shows that it is
compiled for python33 and not python36, and those dependencies are
missing.  Could I replace the plpython3.dll file somehow to get it to work
with Python 3.6?


Surely someone has installed numpy for plpython3u in postgres for Windows,
but I could not find any solutions so far, so I'm reaching out to the
experts.

Thanks

Peter

Re: Seeking the correct term of art for the (unique) role that is usually called "postgres"—and the mental model that underlies it all

[Misty Peters (MistyLynn)]

Can you stop sending me message idk why I need my email back thanks 

Sent from my iPhone

> On Oct 26, 2022, at 7:11 PM, Ian Lawrence Barwick  wrote:
> 
> 2022年10月27日(木) 11:00 David G. Johnston :
>> 
>>> On Wed, Oct 26, 2022 at 6:33 PM Bryn Llewellyn  wrote:
>>> 
>>> The descriptive designation "the role that owns the SQL part of the 
>>> implementation of PostgreSQL" is too much of a mouthful for daily use.
>> 
>> 
>> Don't think it's documented but I like "bootstrap user" which I've seen 
>> bandied about here a bit.
> 
> "bootstrap superuser" is also mentioned a few times in the docs, see e.g.:
> 
>https://www.postgresql.org/docs/devel/sql-grant.html
> 
> This recent commit: e530be2c5ce77475d56ccf8f4e0c4872b666ad5f [1] might
> also be of interest
> to anyone considering the "special-ness" of this role.
> 
> [1] 
> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=e530be2c5ce77475d56ccf8f4e0c4872b666ad5f
> Regards
> 
> Ian Barwick
> 
>