Instal PostgreSQL plpython package on CentOS, Oracle Linux
yum install postgresql94-plpython
Activate plpythonu extension on PostgreSQL
CREATE EXTENSION plpythonu;
Install PostgreSQL database adapter for Python on CentOS, Oracle Linux
yum install python-psycopg2