Search code examples
pythonruby-on-railspostgresqlrails-postgresql

plpythonu.control Missing on Postgres 9.4.0

I'm running Postgres 9.4.0 on my Mac.

I keep getting this error when running my migrations:

PG::UndefinedFile: ERROR: could not open extension control file "/usr/local/Cellar/postgresql/9.4.0/share/postgresql/extension/plpythonu.control": No such file or directory

I checked and (of course) that file is missing from that directory.

I tried doing: 

$ psql 
=# \c abc_dev;
=# CREATE EXTENSION plpythonu;
=# ERROR:  could not open extension control file "/usr/local/Cellar/postgresql/9.4.0/share/postgresql/extension/plpythonu.control": No such file or directory

How can I get the plpythonu.control file into the extension section on my Mac so I can add it to the abc_dev database? Thanks in advance for any advice.

Solution

  • Edit: The standard brew does not include plpython. You can get it to work by using: brew reinstall postgresql --build-from-source --with-python