For some time now I'm trying to get Postgresql running with PL/Python and specifically plpython3u. Being new to all this, a lot of reading brought me to this:
After trying with the packages to no avail I turned to databases/postgresql10-server and later to databases/postgresql10-plpython.
Regardless of what I put after PYTHON (/usr/local/bin/python3, /usr/local/bin/python3.6, /usr/local/bin/python3.6m) no PL/Python seems to be build.
Doing similar with databases/postgresql10-plpython
The above always results in plpythonu and plpython2u being available but not the sought after plpython3u. postgresq10-plpython seems to be hard wired to python2.7.
In need of some guidance,
TIA,
Ingo
After trying with the packages to no avail I turned to databases/postgresql10-server and later to databases/postgresql10-plpython.
Code:
root@db% cd /usr/ports/databases/posgresql10-server
root@db% make fetch
root@db% make extract
root@db% cd /usr/ports/databases/postgresql10-server/work/postgresql-10.5
root@db% ./configure PYTHON=/usr/local/bin/python3 --with-python --with-libraries=/usr/local/lib --with-includes=/usr/local/include/
root@db% cd /usr/ports/databases/posgresql10-server
root@db% make install
Regardless of what I put after PYTHON (/usr/local/bin/python3, /usr/local/bin/python3.6, /usr/local/bin/python3.6m) no PL/Python seems to be build.
Code:
CREATE EXTENSION plpython3u;
"/usr/local/share/postgresql/extension/plpython3u.control": No such file or directory
Doing similar with databases/postgresql10-plpython
Code:
root@db% cd /usr/ports/databases/posgresql10-plpython
root@db% make fetch
root@db% make extract
root@db% cd /usr/ports/databases/postgresql10-plpython/work/postgresql-10.5
root@db% ./configure PYTHON=/usr/local/bin/python3 --with-python --with-libraries=/usr/local/lib --with-includes=/usr/local/include/
root@db% cd /usr/ports/databases/posgresql10-plpython
root@db% make install
The above always results in plpythonu and plpython2u being available but not the sought after plpython3u. postgresq10-plpython seems to be hard wired to python2.7.
In need of some guidance,
TIA,
Ingo