| Lists: | pgsql-general |
|---|
| From: | erobles <erobles(at)sensacd(dot)com(dot)mx> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | ERROR in createlang |
| Date: | 2010-01-04 22:55:35 |
| Message-ID: | 4B4271E7.4080201@sensacd.com.mx |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hi! i have an error when i try to add/create a plpgsql language in
Postgresql 8.3.1 on SCO Openserver 5.0.7
createlang: langauge installation failed: ERROR could not access file
"$libdir/plpgsql": No such file or directory.
But, the file plpgsql.so exists in the directory, please,could you
suugestion to fix that error???.
| From: | Adrian Klaver <aklaver(at)comcast(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Cc: | erobles <erobles(at)sensacd(dot)com(dot)mx> |
| Subject: | Re: ERROR in createlang |
| Date: | 2010-01-05 03:31:06 |
| Message-ID: | 201001041931.07349.aklaver@comcast.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Monday 04 January 2010 2:55:35 pm erobles wrote:
> Hi! i have an error when i try to add/create a plpgsql language in
> Postgresql 8.3.1 on SCO Openserver 5.0.7
> createlang: langauge installation failed: ERROR could not access file
> "$libdir/plpgsql": No such file or directory.
>
>
> But, the file plpgsql.so exists in the directory, please,could you
> suugestion to fix that error???.
Could it be a permissions issue? The file exists but the postgres user does not
have rights to it.
--
Adrian Klaver
aklaver(at)comcast(dot)net
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | erobles <erobles(at)sensacd(dot)com(dot)mx> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: ERROR in createlang |
| Date: | 2010-01-05 04:23:44 |
| Message-ID: | 15617.1262665424@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
erobles <erobles(at)sensacd(dot)com(dot)mx> writes:
> Hi! i have an error when i try to add/create a plpgsql language in
> Postgresql 8.3.1 on SCO Openserver 5.0.7
> createlang: langauge installation failed: ERROR could not access file
> "$libdir/plpgsql": No such file or directory.
> But, the file plpgsql.so exists in the directory, please,could you
> suugestion to fix that error???.
Well, first, are you really sure you know where $libdir points to?
"pg_config --pkglibdir" is the thing to check.
If the directory is right, then my guess would be that the error message
is not complaining about plpgsql.so itself, but about some other shared
library that plpgsql.so depends on. I don't know what the SCO
equivalent of ldd is, but hopefully there's something you can use to
look at a shlib's dependencies.
regards, tom lane