Jean-Christian Imbeault <jc@mega-bucks.co.jp> writes:
> $ createlang plpgsql JC
> ERROR: stat failed on file '$libdir/plpgsql': No such file or directory
> createlang: language installation failed
> But the plpgsql lib exists and is in the right place:
> $ pg_config --pkglibdir
> /usr/local/pgsql/lib
> $ ls -l /usr/local/pgsql/lib | grep plpgsql
> -rwxr-xr-x 1 postgres postgres 95237 Nov 26 18:11 plpgsql.so
Odd --- it works for everyone else (at least everyone who's run the
regression tests).
The only theory I can come up with is that createlang is not talking to
the server you think it is, but some older one (7.1 or before, I guess).
Perhaps check port settings and so forth?
regards, tom lane