Hi,
Recently, I was trying to take advantage of a logging option in Postgres in
which the name of the connecting application is logged along with, well...
the logged statements. Looking at the Postgres documentation, it seems this
feature is new as of 9.x, and in order to take advantage, the calling
application has to identify itself - either through an explicit SET
command, or via a connection parameter.
However, when I tried to do this, I didn't get any expected results. My
logs still showed "unknown" for the application name, instead of what I set
it to in Geoserver's datastore config.
Looking into it further, I noticed that the current version of Geoserver is
using an older version of the Postgres JDBC driver (the file in the webapp
is named "postgresql-8.4-701.jdbc3.jar"). Curious, I downloaded the latest
version ("postgresql-9.2-1002.jdbc4.jar") and manually installed it in
Geoserver's "lib" folder and restarted. Voila! My application name is now
getting set when Geoserver makes a connection.
My question is: is there a reason why this older driver is still being
distributed with the latest stable Geoserver releases? Additionally, are
there any known incompatibilities that I should be aware of before I go
ahead and try using this newer driver?
Thanks,
Doug
------------------------------------------------------------------------------
Keep yourself connected to Go Parallel:
TUNE You got it built. Now make it sing. Tune shows you how.
http://goparallel.sourceforge.net
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users
