Обсуждение: Installing plpgsql fails

Hi

Solaris 8
PG V7.3.3

I'm trying to install the procedural language plpgsql using:

createlang plpgsql securnet

But this fails with:

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

pg_config --libdir  - returns:

/opt/postgres/product/7.3.3/lib - and in this directory resides a file called plpgsql.so

The LD_LIBRARY_PATH variable also contains /opt/postgres/product/7.3.3/lib


I've installed this successfully on another Solaris box without a problem.

Has anyone got any thoughts?

Thanks

Regards

Nigel Bishop

Hi,

edit the script called "createlang" and adjust PGLIB='$libdir'.

regards

-Andreas



On Wednesday 08 October 2003 13:19, Nigel Bishop wrote:
> Hi
>
> Solaris 8
> PG V7.3.3
>
> I'm trying to install the procedural language plpgsql using:
>
> createlang plpgsql securnet
>
> But this fails with:
>
> ERROR:  stat failed on file '$libdir/plpgsql': No such file or directory
> createlang: language installation failed
>
> pg_config --libdir  - returns:
>
> /opt/postgres/product/7.3.3/lib - and in this directory resides a file
> called plpgsql.so
>
> The LD_LIBRARY_PATH variable also contains /opt/postgres/product/7.3.3/lib
>
>
> I've installed this successfully on another Solaris box without a problem.
>
> Has anyone got any thoughts?
>
> Thanks
>
> Regards
>
> Nigel Bishop
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings

--
Andreas Schmitz - Phone +49 201 8501 318
Cityweb-Technik-Service-Gesellschaft mbH
Friedrichstr. 12 - Fax +49 201 8501 104
45128 Essen - email a.schmitz@cityweb.de

"Nigel Bishop" <Nigel.Bishop@ioko.com> writes:
> ERROR:  stat failed on file '$libdir/plpgsql': No such file or directory
> createlang: language installation failed

> pg_config --libdir  - returns:

I think the pg_config setting you need to look at is --pkglibdir.

            regards, tom lane

Tom,

I tried what Andreas Schmitz suggested (setting PGLIB=/opt/postgres/product/7.3.3/lib in the createlang script), it
didn'treturn an error but there again it didn't return the CREATELANG message either.  Though if I then run the
"createlandlang db" again it says that the language is installed.  Selecting from pg_language does not show the plpgsql
language.

Running pg_config --pkglibdir returns - /opt/postgres/product/7.3.3/lib

When postgres was installed on this machine back in July the configure script was ran with:

./configure --prefix=/opt/postgres/product/7.3.3

Could this make a difference

I was trying to run the dbsize.sql script which fails (ERROR:  stat failed on file '$libdir/plpgsql': No such file or
 directory) because the language isn't installed hence why I'm trying to install the lanaguage.

Regards


Nigel Bishop




-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: 08 October 2003 23:14
To: Nigel Bishop
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Installing plpgsql fails


"Nigel Bishop" <Nigel.Bishop@ioko.com> writes:
> ERROR:  stat failed on file '$libdir/plpgsql': No such file or
> directory
> createlang: language installation failed

> pg_config --libdir  - returns:

I think the pg_config setting you need to look at is --pkglibdir.

            regards, tom lane