Issue in Installing PL/Python on Postgres

[IshaanAdarsh]

I want to install PL/Python on my postgres database. I am using a binary manager on postgres pgenv. These are the steps I am following to install the procedural language:

• I have downloaded the PL/Python source code from the PostgreSQL contrib repository

• After connecting to the PL/Python source code directory, i run the commands

make 
make install

• I am getting the error:

Makefile:5: ../../../src/Makefile.global: No such file or directory
Makefile:103: /src/Makefile.shlib: No such file or directory
make: *** No rule to make target `/src/Makefile.shlib'.  Stop.
Makefile:5: ../../../src/Makefile.global: No such file or directory
Makefile:103: /src/Makefile.shlib: No such file or directory
make: *** No rule to make target `/src/Makefile.shlib'.  Stop.

The error occurs because the build process for PL/Python is unable to locate the necessary PostgreSQL source files and makefiles. I have already checked and verified that the pg_config environment variable is pointing to the correct path.

[IshaanAdarsh]

Stack Overflow: https://stackoverflow.com/questions/76738792/issue-in-installing-pl-python-on-postgres

[IshaanAdarsh]

Tried the solution: modify the build per the instructions here pgenv: pgenv build The example shows doing that for plperl using --with-perl. The corresponding argument for plpythonu would be --with-python.

but this didn’t work, still getting the same error.

[IshaanAdarsh]

@theory, any suggestions

[theory]

I don't use PL/Python, but I would have thought that would work. Do you have the Python dev libraries installed? I know I have to compile Perl with -Duseshrplib -Dusemultiplicity in order to get the dynamic library that Postgres requires. You might also have to point to the directories for Python in your build.

[IshaanAdarsh]

I have the Python libraries installed, I will try this out.