Pages

Friday, September 24, 2010

Postgres - 8.3 - Plpython -ERROR: could not access file "$libdir/plpython": No such file or directory

I wanted to do some programming plpython in Postgres
To add a language we need to use the following query

create language plpythonu


When I run this query, I  was struck up in the following error


"ERROR:  could not access file "$libdir/plpython": No such file or directory"


So I google a lot and atlast found the solution .

The problem was plpython package was not installed.

To run plpython routines and procedures,we need the following packages.

postgresql-8.3 (By default postgres-8.3 will be installed)
postgresql-contrib-8.3
postgresql-plpython-8.3

I was using BOSS, a debian derived linux.
I installed the packages with the command


apt-get install postgresql-contrib-8.3

apt-get install postgresql-plpython-8.3


Then I run the same query,

create language plpythonu

Success, that problem was resolved !!!!!





No comments:

Post a Comment