Re: Error CREATE EXTENSION plpythonu

1. Install PostgreSQL and install latest language pack installer with default options
2. open terminal with su - postgres and perform following operation using same terminal
3. go into bin folder
4. ./pg_ctl -D /opt/PostgreSQL/9.4/data stop -o "-p 5432"

For Linux:

export LD_LIBRARY_PATH=/opt/edb/languagepack-9.6/Python-3.3/lib/:$LD_LIBRARY_PATH
export PATH=/opt/edb/languagepack-9.6/Python-3.3/bin/:$PATH
export PYTHONHOME=/opt/edb/languagepack-9.6/Python-3.3
export PYTHONPATH=/opt/edb/languagepack-9.6/Python-3.3

For MAC:

export LD_LIBRARY_PATH=/Library/edb/languagepack-9.6/Python-3.3/lib/:$LD_LIBRARY_PATH
export PATH=/Library/edb/languagepack-9.6/Python-3.3/bin/:$PATH
export PYTHONHOME=/Library/edb/languagepack-9.6/Python-3.3
export PYTHONPATH=/Library/edb/languagepack-9.6/Python-3.3

(Set environment variable on windows:

Right click on My computer->properties->Advanced System
Settings->Advanced tab->Environment Variables button->System
variables

For Windows 32:

C:\edb\languagepack-9.6\i386\Python-3.3;C:\edb\languagepack-9.6\i386\Perl-5.20\bin;C:\edb\languagepack-9.6\i386\Tcl-8.5\bin;
PYTHONHOME=C:\edb\languagepack-9.6\i386\Python-3.3

For Windows 64:

C:\edb\languagepack-9.6\x64\Python-3.3;C:\edb\languagepack-9.6\x64\Perl-5.20\bin;C:\edb\languagepack-9.6\x64\Tcl-8.5\bin;
PYTHONHOME=C:\edb\languagepack-9.6\x64\Python-3.3
Restart windows VM)

1. ./pg_ctl -D /opt/PostgreSQL/9.4/data start -o "-p 5432"
2. open psql

3. create language plpython3u;
   CREATE LANGUAGE plpython3u;

4. Check functionality

CREATE FUNCTION pymax (a integer, b integer) RETURNS integer AS $$ if a > b: return a return b $$ LANGUAGE plpython3u;

You can call the function (pymax), passing two values:

SELECT pymax(1, 2);