pljava and Postgres 9.2.1

Started by Misa Simicover 13 years ago3 messagesgeneral
Jump to latest
#1Misa Simic
misa.simic@gmail.com

Hi,

We have a bit strange error with pljava deploy and postgresql 9.2.1...

We are not sure is it related to pljava itself, because of when we add to
postgresql.conf:

custom_variable_classes = 'pljava'

we cant start Postgres any more...

server log says;

LOG: unrecognized configuration parameter "custom_variable_classes" in
file "/usr/local/pgsql/data/postgresql.conf" line 574
FATAL: configuration file "/usr/local/pgsql/data/postgresql.conf" contains
errors

if we comment that line - postgres starts fine...

OS: Ubuntu 12.04

pljava 1.4.3 compiled with: java -version
java version "1.5.0"
gij (GNU libgcj) version 4.6.3

install.sql of pljava - passed fine, without problems...

but an call to an java function says (Postgresql function - CREATE function
language java - passed fine):

ERROR: Unable to load class org/postgresql/pljava/internal/Backend using
CLASSPATH 'null'

then we have tried to add in postgresql.conf

#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------

# Add settings for extensions here
custom_variable_classes = 'pljava'
pljava.classpath = '/usr/local/pgsql/lib/pljava.jar'

on the end...

but after that we cant start Postgresql any more.. (those two lines
commented - Postgres starts fine)

Any ideas?

Thanks,

Misa

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Misa Simic (#1)
Re: pljava and Postgres 9.2.1

Misa Simic <misa.simic@gmail.com> writes:

We have a bit strange error with pljava deploy and postgresql 9.2.1...

We are not sure is it related to pljava itself, because of when we add to
postgresql.conf:

custom_variable_classes = 'pljava'

we cant start Postgres any more...

custom_variable_classes is no longer needed, and has been removed. See
the 9.2 release notes.

regards, tom lane

#3Misa Simic
misa.simic@gmail.com
In reply to: Tom Lane (#2)
Re: pljava and Postgres 9.2.1

Thanks Tom,

without custom_variable_classes = 'pljava'

but with pljava.classpath = pathTopljava.jar

everything works fine..

Many thanks,

Misa

2012/9/25 Tom Lane <tgl@sss.pgh.pa.us>

Show quoted text

Misa Simic <misa.simic@gmail.com> writes:

We have a bit strange error with pljava deploy and postgresql 9.2.1...

We are not sure is it related to pljava itself, because of when we add to
postgresql.conf:

custom_variable_classes = 'pljava'

we cant start Postgres any more...

custom_variable_classes is no longer needed, and has been removed. See
the 9.2 release notes.

regards, tom lane