Hi Monica,

On Tue, 2007-02-27 at 12:34 -0500, Monika Mevenkamp wrote:
> I tried to install the MinHo  stats package for my test instance but
> hit a snag  when I tried to install the pljava package, I tried to
> proceed according to your install instructions. 

we have installed the Statistics Add-on on 1.3.2, and I'm currently
installing it on our test/development server running 1.4.1.

The install instructions could be a bit more clear, I agree! :) (The
pljava wiki seems to be working now, btw)

> Below is a what gives me grief:

[ snip ]

> > psql -d smartech 
> Welcome to psql 8.1.8, the PostgreSQL interactive terminal.
> 
> Type:  \copyright for distribution terms
>        \h for help with SQL commands 
>        \? for help with psql commands 
>        \g or terminate with semicolon to execute query
>        \q to quit
> 
> smartech=# \i uninstall.sql
> psql:uninstall.sql:1: ERROR:  language "java" does not exist 

[ snip ]

Yeah, got this one as well... You need to run the command:
'createlang -U <postgres_user> plpgsql <database>' before you try to
install the pljava thingy...

Use 'createlang -l' to see which languages that's installed.

I also found it "easier" to use the PL/Java Deployer program than the
install.sql script... as the postgres user run:
java -cp <path_to_postgresql.jar:path_to_deployer.jar>
org.postgresql.pljava.deploy.Deployer -install -database <database>

That should do the trick. (famous last words) ;)

You will also probably find a few things in the installation procedure
of the actual statistics add-on that doesn't work.... I did, anyway.
I'm trying to sum it up and ask for the maintainers of the add-on to
update their docs with it... Just got to find the time to do it!

Good luck!

Kind regards
Bjorn Skobba
Brunel University, UK


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Reply via email to