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). If it matters, my python 3 is in /usr/local/bin/python3.
I'm having problems installing plpython3u, this is my situation: I have installed postgresql-9.3.5 in my home directory, from source. I used (from my memory, it might not be exact)
./configure --prefix=$HOME; make; make install
Now I need to upload a database which requires plpython3u, and this is what happens:
pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 1590; 2612 24721 PROCEDURAL LANGUAGE plpython3u dberaldi pg_restore: [archiver (db)] could not execute query: ERROR: could not access file "$libdir/plpython3": No such file or directory Command was: CREATE OR REPLACE PROCEDURAL LANGUAGE plpython3u;
If I try to create plpython3u I get:
createlang plpython3u sblab createlang: language installation failed: ERROR: could not open extension control file "/data/sblab-home/berald01/share/postgresql/extension/plpython3u.control": No such file or directory
"Tip: The built variant depends on which Python version was found during the installation or which version was explicitly set using the PYTHON environment variable; see Section 15.4. To make both variants of PL/Python available in one installation, the source tree has to be configured and built twice."