Re: Installing plpython3u

On 15 October 2015 at 14:46, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Dario Beraldi <dario(dot)beraldi(at)gmail(dot)com> writes:
> > Thanks for your answer. Just checking before I screw things up... About
> > "the source tree has to be configured and built twice", does it mean
> that I
> > have to execute again
>
> > ./configure --prefix=$HOME;
> > make;
> > make install
>
> > And should I enable any particular option in ./configure? I see there is
> a
> > "--with-python" option (not specific to python3 though).
>
> Indeed --- you have not built any version of plpython here. You need
> --with-python, and you need to make sure the PYTHON environment variable
> is set (else you'll get whatever version is invoked by "python", which is
> most likely python2). See the build instructions in the documentation.
> Also watch the output from configure, which will show you which python
> it selected.
>
> regards, tom lane
>

Sorry guys... I executed

./configure --prefix=$HOME --with-python PYTHON=/usr/local/bin/python3
make
make install

and it completed fine (see also below output from 'grep -i 'PYTHON'
config.log'). Still after restarting postgres I get:

createlang plpython3u sblab
ERROR: could not open extension control file
"/data/sblab-home/berald01/share/postgresql/extension/plpython3u.control":
No such file or directory
STATEMENT: CREATE EXTENSION "plpython3u";

## From config.log
grep -i 'PYTHON' config.log

$ ./configure --prefix=/Users/berald01 --with-python
PYTHON=/usr/local/bin/python3
PATH: /opt/rh/python27/root/usr/bin
configure:5399: checking whether to build Python modules
configure:7499: checking for python
configure:7529: result: /usr/local/bin/python3
configure:7544: checking for Python distutils module
configure:7557: checking Python configuration directory
configure:7562: result: /usr/local/lib/python3.4/config-3.4m
configure:7565: checking Python include directories
configure:7575: result: -I/usr/local/include/python3.4m
configure:7580: checking how to link an embedded Python application
configure:7607: result: -L/usr/local/lib/python3.4/config-3.4m -lpython3.4m
-lpthread -ldl -lutil -lm
configure:7612: checking whether Python is compiled with thread support
configure:29636: checking Python.h usability
configure:29653: gcc -c -O2 -Wall -Wmissing-prototypes -Wpointer-arith
-Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute
-Wformat-security -fno-strict-aliasing -fwrapv
-I/usr/local/include/python3.4m -D_GNU_SOURCE conftest.c >&5
configure:29678: checking Python.h presence
configure:29693: gcc -E -I/usr/local/include/python3.4m -D_GNU_SOURCE
conftest.c
configure:29747: checking for Python.h
ac_cv_header_Python_h=yes
ac_cv_path_PYTHON=/usr/local/bin/python3
PYTHON='/usr/local/bin/python3'
configure_args=' '\''--prefix=/Users/berald01'\'' '\''--with-python'\''
'\''PYTHON=/usr/local/bin/python3'\'''
python_additional_libs='-lpthread -ldl -lutil -lm'
python_enable_shared='0'
python_includespec='-I/usr/local/include/python3.4m'
python_libdir='/usr/local/lib/python3.4/config-3.4m'
python_libspec='-L/usr/local/lib/python3.4/config-3.4m -lpython3.4m'
python_majorversion='3'
python_version='3.4'
with_python='yes'