I have installed Postgresql@14 on my system using homebrew. I want to install pl/python on my database but on running the command CREATE EXTENSION plpython3u;
ERROR: could not open extension control file "/opt/homebrew/share/postgresql@14/extension/plpython3u.control": No such file or directory
As the files for PL/Python are not pre-installed in this homebrew version. I tried to install from source.
but on running make and make install command, getting the same error for both:
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.
How can i install Pl/Python on my Homebrew Postgresql@14?
The steps to install PL/Python on Homebrew - installed PostgreSQL are as follows:
a. Install Xcode CLI
b. Make sure there is python installed on the system and go to PostgreSQL downloads page and install that.
c. Extract source code from the file that you have downloaded.
d. Configure the build and install PostgreSQL.
e. Now build and install PL/Python.
Following these steps should help you with the installation of PostgreSQL