<br><br>Hi all,<br><br> I think u've already installed the postgresql previous version.so that's postgres instance is removed<br>from registry.<br><br>Thanks and regards<br><br><br><div class="gmail_quote">On Mon, May 31, 2010 at 7:50 PM, Luca Ferrari <span dir="ltr"><<a href="mailto:fluca1978@infinito.it">fluca1978@infinito.it</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hi all,<br>
this is the system that I'm using:<br>
<br>
<br>
Linux fluca-laptop 2.6.31-19-generic #56-Ubuntu SMP Thu Jan 28 02:39:34 UTC<br>
2010 x86_64 GNU/Linux<br>
<br>
select version();<br>
version<br>
-------------------------------------------------------------------------------------------------------------<br>
PostgreSQL 8.4.3 on x86_64-pc-linux-gnu, compiled by GCC gcc-4.4.real (Ubuntu<br>
4.4.1-4ubuntu9) 4.4.1, 64-bit<br>
(1 row)<br>
<br>
I've downloaded the pljava1.4 64 bit version, I've uncompressed and checked<br>
that the pljava.so library is ready to work:<br>
<br>
$ ldd pljava.so<br>
linux-vdso.so.1 => (0x00007fff180bf000)<br>
libjvm.so => /usr/lib/jvm/java-6-<br>
sun-1.6.0.20/jre/lib/amd64/server/libjvm.so (0x00007f0b46a34000)<br>
libc.so.6 => /lib/libc.so.6 (0x00007f0b466c5000)<br>
libm.so.6 => /lib/libm.so.6 (0x00007f0b46440000)<br>
libdl.so.2 => /lib/libdl.so.2 (0x00007f0b4623c000)<br>
libpthread.so.0 => /lib/libpthread.so.0 (0x00007f0b46020000)<br>
/lib64/ld-linux-x86-64.so.2 (0x00007f0b47707000)<br>
<br>
<br>
Since I'm using the java vm provided by my Ubuntu distro, I've placed the<br>
following lines in the <a href="http://ld.conf.so" target="_blank">ld.conf.so</a>:<br>
<br>
/usr/lib/jvm/java-6-sun-1.6.0.20/jre/lib/amd64/server/<br>
/usr/lib/jvm/java-6-sun-1.6.0.20/jre/lib/amd64/native_threads/<br>
<br>
and restarted the postmaster.<br>
Now I believe I've configured everything, but when I try to run the deploy<br>
program I get an PSQLException that pljava.so cannot be loaded:<br>
<br>
org.postgresql.util.PSQLException: ERROR: could not load library<br>
"/sviluppo/java/pljava/pljava.so": /sviluppo/java/pljava/pljava.so: undefined<br>
symbol: global_timezone<br>
at<br>
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)<br>
at<br>
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)<br>
at<br>
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)<br>
at<br>
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)<br>
at<br>
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)<br>
at<br>
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)<br>
at<br>
org.postgresql.pljava.deploy.Deployer.initJavaHandlers(Deployer.java:474)<br>
at org.postgresql.pljava.deploy.Deployer.main(Deployer.java:269)<br>
<br>
and in the server logs I found the following that is the same error:<br>
<br>
ERROR: could not load library "/sviluppo/java/pljava/pljava.so":<br>
/sviluppo/java/pljava/pljava.so: undefined symbol: global_timezone<br>
<br>
<br>
Any idea about how to configure pljava on the system?<br>
<br>
Thanks,<br>
Luca<br>
_______________________________________________<br>
Pljava-dev mailing list<br>
<a href="mailto:Pljava-dev@pgfoundry.org">Pljava-dev@pgfoundry.org</a><br>
<a href="http://pgfoundry.org/mailman/listinfo/pljava-dev" target="_blank">http://pgfoundry.org/mailman/listinfo/pljava-dev</a><br>
</blockquote></div><br><br clear="all"><br>-- <br>Chnvv Raghavendra<br>Mobile:9908898985<br>