Package: postgresql-8.3-plr Version: 1:8.3.0.6-1 Severity: normal Running psql db < /usr/share/postgresql/8.3/plr.sql returns the following error: ERROR: could not load library "/usr/lib/postgresql/8.3/lib/plr.so": libR.so: ca nnot open shared object file: No such file or directory
It was running in a vserver, if that's relevant. To fix it: 1. Run ldconfig 2. Modify /etc/postgresql/8.3/main/environment Add line: R_HOME = '/usr/lib/R/' Also 'createlang plr db' does not work as expected for 'createlang plpythonu db' etc This is because there's no entry for plr in pg_pltemplate That's less of a problem considering the readme does state to use: psql db < /us r/share/postgresql/8.3/plr.sql The fix is fairly easy to do at the configuration stage, but it would be useful to at least have it stated in the readme, rather than having to go the original website to track down the issue. -- System Information: Debian Release: lenny/sid APT prefers unstable APT policy: (500, 'unstable'), (500, 'testing') Architecture: i386 (i686) Kernel: Linux 2.6.26-1-vserver-686 (SMP w/1 CPU core) Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8) Shell: /bin/sh linked to /bin/bash Versions of packages postgresql-8.3-plr depends on: ii libc6 2.7-16 GNU C Library: Shared libraries ii postgresql-8.3 8.3.5-1 object-relational SQL database, ve ii r-base-core 2.8.0-1 GNU R core of statistical computat postgresql-8.3-plr recommends no packages. Versions of packages postgresql-8.3-plr suggests: ii r-recommended 2.8.0-1 GNU R collection of recommended pa -- no debconf information -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
