X-Original-To: pgsql-bugs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.192]) by svr1.postgresql.org (Postfix) with ESMTP id B3117CCB0D for ; Thu, 17 Jul 2003 21:11:41 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new, port 10024) with ESMTP id 79624-08 for ; Thu, 17 Jul 2003 21:12:08 +0000 (GMT) Received: from jive.SoftHome.net (jive.SoftHome.net [66.54.152.27]) by svr1.postgresql.org (Postfix) with SMTP id 438C4CCB01 for ; Thu, 17 Jul 2003 18:11:39 -0300 (ADT) Received: (qmail 24040 invoked by uid 417); 17 Jul 2003 21:12:09 -0000 Received: from slide-.softhome.net (HELO softhome.net) (172.16.2.21) by shunt-smtp-out-0 with SMTP; 17 Jul 2003 21:12:09 -0000 Received: from localhost (localhost [127.0.0.1]) (uid 417) by softhome.net with local; Thu, 17 Jul 2003 15:12:09 -0600 References: In-Reply-To: From: cookfire@softhome.net To: pgsql-interfaces@postgresql.org, pgsql-bugs@postgresql.org Subject: PL/PGSQL stat failed on file '$libdir/plpgsql' Date: Thu, 17 Jul 2003 15:12:09 -0600 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Sender: cookfire@softhome.net X-Originating-IP: [134.58.253.129] Message-ID: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200307/100 X-Sequence-Number: 6314 Hi, Since Linux Mandrake 9.1 came out, I have this problem with pl/pgsql: [root@localhost jo]# su postgres bash-2.05b$ createdb test CREATE DATABASE bash-2.05b$ createlang plpgsql test ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation failed bash-2.05b$ bash-2.05b$ Does anybody know what is going on? Following a hint found with google: bash-2.05b$ pg_config --pkglibdir bash: pg_config: command not found bash-2.05b$ exit exit [root@localhost jo]# pg_config --pkglibdir bash: pg_config: command not found [root@localhost jo]# echo $libdir [root@localhost jo]# What should this variable contain? [root@localhost jo]# cd /usr/local [root@localhost local]# ls bin/ doc/ etc/ games/ include/ lib/ libexec/ pgsql/ sbin/ share/ src/ vortaro/ [root@localhost local]# cd pgsql [root@localhost pgsql]# ls bin/ doc/ include/ lib/ man/ share/ [root@localhost pgsql]# cd lib [root@localhost lib]# ls ascii_and_mic.so* latin2_and_win1250.so* libpq.a utf8_and_big5.so* utf8_and_gb18030.so* utf8_and_tcvn.so* cyrillic_and_mic.so* latin_and_mic.so* libpq.so@ utf8_and_cyrillic.so* utf8_and_gbk.so* utf8_and_uhc.so* euc_cn_and_mic.so* libecpg.a libpq.so.3@ utf8_and_euc_cn.so* utf8_and_iso8859_1.so* utf8_and_win1250.so* euc_jp_and_sjis.so* libecpg.so@ libpq.so.3.0* utf8_and_euc_jp.so* utf8_and_iso8859.so* utf8_and_win1256.so* euc_kr_and_mic.so* libecpg.so.3@ plpgsql.so* utf8_and_euc_kr.so* utf8_and_johab.so* utf8_and_win874.so* euc_tw_and_big5.so* libecpg.so.3.4.1* utf8_and_ascii.so* utf8_and_euc_tw.so* utf8_and_sjis.so* [root@localhost lib]# Is everything present? [root@localhost lib]# su postgres bash-2.05b$ echo $libdir bash-2.05b$ export libdir=/usr/local/pgsql/lib bash-2.05b$ echo $libdir /usr/local/pgsql/lib bash-2.05b$ createlang plpgsql test ERROR: stat failed on file '$libdir/plpgsql': No such file or directory createlang: language installation failed bash-2.05b$ I'm stuck, hope anybody can help me out Many thanks, Jo