createlang plpgsql error - Mailing list pgsql-general

From Jim Martinez
Subject createlang plpgsql error
Date
Msg-id Pine.LNX.4.33.0212101042390.18370-100000@unagi.e-techservices.com
Whole thread Raw
Responses Re: createlang plpgsql error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm having trouble installing plpgsql.  Here's the error:

[postgres@shimzilla home]$ createlang plpgsql template1
ERROR:  stat failed on file '$libdir/plpgsql': No such file or directory
createlang: language installation failed

[postgres@shimzilla home]$psql template1
Welcome to psql 7.3, the PostgreSQL interactive terminal.
template1=# select version();
                          version
-----------------------------------------------------------
 PostgreSQL 7.3 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)

Some more info:
This is on a RedHat 7.3, with Postgresql 7.3, on an intel box.

I built from source, and configured with one option:
./configure --prefix=/opt/pgsql

After I configured I had to edit /etc/ld.so.conf adding the line:
/opt/pgsql/lib

Then I ran ldconfig.

I installed in /opt instead of /usr/local because I want this install to
be the same as a solaris install.  In fact I first installed in /usr/local
with no problems at all before deciding that overall it'd be better to
have the installs on the two servers be as identical as possible.  The
first install was removed with "make uninstall"

Any ideas or pointers to urls?

Thanks in advance,
Jim Martinez





pgsql-general by date:

Previous
From: Doug Fields
Date:
Subject: Large import via temporary table: all at once, or split into chunks?
Next
From: Steve Crawford
Date:
Subject: Re: Time functions