pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedPL/PGSQL stat failed on file '$libdir/plpgsql'
3+ messages / 2 participants
[nested] [flat]
* PL/PGSQL stat failed on file '$libdir/plpgsql'
@ 2003-07-17 21:12 cookfire@softhome.net
0 siblings, 1 reply; 3+ messages in thread
From: cookfire@softhome.net @ 2003-07-17 21:12 UTC (permalink / raw)
To: pgsql-interfaces; pgsql-bugs@postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] PL/PGSQL stat failed on file '$libdir/plpgsql'
@ 2003-07-17 21:25 Tom Lane <tgl@sss.pgh.pa.us>
parent: cookfire@softhome.net
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2003-07-17 21:25 UTC (permalink / raw)
To: cookfire@softhome.net; +Cc: pgsql-interfaces; pgsql-bugs@postgresql.org
cookfire@softhome.net writes:
> bash-2.05b$ pg_config --pkglibdir
> bash: pg_config: command not found
If you can't find pg_config you had better figure out why not. Either
your PATH setting doesn't include the directory where Postgres
executables were installed, or you have a very old or broken Postgres.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: PL/PGSQL stat failed on file '$libdir/plpgsql'
@ 2003-07-18 09:00 cookfire@softhome.net
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: cookfire@softhome.net @ 2003-07-18 09:00 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-interfaces; pgsql-bugs@postgresql.org
After installing all these packages, it seems to work now:
[root@localhost win_e]# urpme postgres
The following packages contain postgres: postgresql-7.3.2-5mdk
postgresql-tcl-7.3.2-5mdk postgresql-test-7.3.2-5mdk
postgresql-docs-7.3.2-5mdk postgresql-python-7.3.2-5mdk
postgresql-devel-7.3.2-5mdk postgresql-server-7.3.2-5mdk
postgresql-pl-7.3.2-5mdk postgresql-contrib-7.3.2-5mdk
I am convinced I had already tried that. With onlyh postgresql and
postgresql-server it doesn't work.
Many thanks for your help!
Jo
Tom Lane writes:
> cookfire@softhome.net writes:
>> bash-2.05b$ pg_config --pkglibdir
>> bash: pg_config: command not found
>
> If you can't find pg_config you had better figure out why not. Either
> your PATH setting doesn't include the directory where Postgres
> executables were installed, or you have a very old or broken Postgres.
>
> regards, tom lane
Member of Linux MandrakeClub
http://www.mandrakeclub.com
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2003-07-18 09:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-17 21:12 PL/PGSQL stat failed on file '$libdir/plpgsql' cookfire@softhome.net
2003-07-17 21:25 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-07-18 09:00 ` cookfire@softhome.net
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox