From: | "John Liu" <johnl(at)emrx(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: createlang failed! |
Date: | 2003-01-17 15:38:47 |
Message-ID: | NDBBKKKHILOHGHNKGOCEKEKAEKAA.johnl@emrx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thanks, fixed. The problem was
caused -
there's a postgreSQL came with the
Redhat server, but I tried to install one
only used by a specific user, I set
LD_LIBRARY_PATH in this user's profile.
pg_config --pkglibdir points to the correct
lib dir, but when I run createlang plpgsql template1
it keeps failed.
I've to run -
createlang --pglib=Dir plpgsql template1
then:
createlang -l template1
Procedural languages
Name | Trusted?
---------+----------
plpgsql | t
(1 row)
But here's another observation -
I still can't create plpgsql in the mydb
(createdb mydb) even template1 supports plpgsql.
I've to run
createlang --pglib=Dir --dbname=DB plpgsql.
I guess it's me to make it messy.
johnl
> -----Original Message-----
> From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
> Sent: Friday, January 17, 2003 9:15 AM
> To: John Liu
> Cc: pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] createlang failed!
>
>
> "John Liu" <johnl(at)synthesys(dot)com> writes:
> > When I run createlang plpgsql template1
> > on linux 7.3 (pg version 7.3.1), it failed -
>
> > createlang plpgsql template1
> > ERROR: stat failed on file '$libdir/plpgsql': No such file or directory
> > createlang: language installation failed
>
> What does 'pg_config --pkglibdir' say? Is there a plpgsql.so in there?
> Is there any additional information about the failure in the
> postmaster's log? (If you are routing the postmaster's stderr to
> /dev/null, now is a good time to stop doing that --- what I'm wondering
> about is dynamic-linker errors, which will only appear on stderr.)
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-17 15:46:29 | Re: createlang failed! |
Previous Message | Claudio Lapidus | 2003-01-17 15:29:00 | Re: [GENERAL] Translation of the PostgreSQL manuals to Spanish is under way |