Re: [HACKERS] createlang failed!
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:[EMAIL PROTECTED]] Sent: Friday, January 17, 2003 9:15 AM To: John Liu Cc: [EMAIL PROTECTED] Subject: Re: [HACKERS] createlang failed! John Liu [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] createlang failed!
John Liu [EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [HACKERS] createlang failed!
John Liu [EMAIL PROTECTED] writes: 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 suspect that the linker is ignoring LD_LIBRARY_PATH in favor of the ldconfig path. Or it might just be that you neglected to ensure that LD_LIBRARY_PATH is actually set in the environment of the running postmaster. regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly