Thread: 7.3RC2 createlang error

I've gotten 7.3RC2 installed but now I get an error trying to install a
language:

$ createdb JC
CREATE DATABASE
$ createlang plpgsql JC
ERROR:  stat failed on file '$libdir/plpgsql': No such file or directory
createlang: language installation failed

Did I forget to do something during the configuration or installation? I
check the 7.2 docs but they have no mention of creatlang.

Jc

A follow-up to my createlang problems. I thought it might be related to
a conflict between a lib from an older version so I deleted the older
version and re-installed the newer version.

But I still get the same error:

$ 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

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

Tom Lane wrote:
>
>>$ createlang plpgsql JC
>>ERROR:  stat failed on file '$libdir/plpgsql': No such file or directory
>>createlang: language installation failed
>
> 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?

I posted a follow-up to this on the BUGS list.

I had to manually edit the bin/createlang script and hard code the path
to PGLIB. It wasn't automatically picking it up even though it was
properly and pointing to the right place.

I have no idea why ...

I'm not happy with this as my solution is hack, and worse it's a hack to
  a problem whose reason I don't understand.

I'd be happy to to more testing if you tell we what is needed.

Jc