CODEWITHSUNDEEP
postgresql
Mr. Zen
Mr. Zen

Reputation: 712

Postgres plpythonu extension doesn't exist in /usr/pgsql-9.3/share/extension

When I try to enable plythonu by using 

CREATE EXTENSION plpythonu

I get error 

ERROR:  could not open extension control file "/usr/pgsql-9.3/share/extension/plpythonu.control": No such file or directory

The extension folder has no file with that name.

Is there a download link? How can I add plpythonu?

Upvotes: 16

Views: 9439

Answers (1)

Craig Ringer
Craig Ringer

Reputation: 324741

PL/Python isn't installed. In most Linux packages of PostgreSQL it's a separate package.

If you're using apt.postgresql.org (PGDG) packages on Debian/Ubuntu:

apt-get install postgresql-contrib-9.3 postgresql-plpython-9.3

If you're on Ubuntu or Debian with their stock PostgreSQL packages:

apt-get install postgresql-contrib postgresql-plpython

If you're on Fedora/CentOS/RhEL with PGDG packages from yum.postgresql.org:

yum install postgresql93-contrib postgresql93-plpython

If you're on Fedora/CentOS/RHEL with stock packages:

yum install postgresql-contrib postgresql-plpython

The contrib packages aren't strictly required, but you're likely to want them too.

Upvotes: 37

Related Questions