[Geoserver-users] Point Geoserver to official EPSG database in PostgreSQL?

Hello. I've tried searching the archives but sf.net seems broken at the moment. Apologies if this is a repeat.

I need to use a more recent version of the EPSG database than the one shipped with Geoserver/Geotools. And truthfully, this is probably going to be a recurring problem for me so it seems wise to point to the official version rather than trying to retrofit new entries into Geoserver.

Could someone please provide me with some info on how to point geoserver to a copy of the epsg database in postgres vs. using the hsqldb one? I've heard that it is possible and that some people are doing it... I just haven't been able to find any docs or how-tos.

The best I have found is: <http://docs.codehaus.org/x/SQ4B&gt; but it doesn't help me much unfortunately.

Thanks in advance!

--
Amos Hayes
Geomatics and Cartographic Research Centre
Carleton University
ahayes@anonymised.com
+1.613.520.2600x8179

Amos Hayes ha scritto:

Hello. I've tried searching the archives but sf.net seems broken at the moment. Apologies if this is a repeat.

I need to use a more recent version of the EPSG database than the one shipped with Geoserver/Geotools.

Geoserver 1.5.0 ships with the latest and the greatest afaik.
We're releasing with version 6.12, which is the latest one.

And truthfully, this is probably going to be a recurring problem for me so it seems wise to point to the official version rather than trying to retrofit new entries into Geoserver.

Could someone please provide me with some info on how to point geoserver to a copy of the epsg database in postgres vs. using the hsqldb one? I've heard that it is possible and that some people are doing it... I just haven't been able to find any docs or how-tos.

Possible it is, but nobody among the Geoserver team has even tried
to do it as far as I know. The best directions I could find are here:
http://www.geotools.fr/javadoc/2.3/org/geotools/referencing/factory/epsg/PostgreDataSource.html

Please do note that the EPSG database structure has not been
totally stable, and for example we had to upgrade our code
to make it work with 6.12 (the code was working ok with 6.8),
so upgrading the DB may break your install.

Anyways, if you succeed in doing that install, are you interested
in writing some docs about that? Confluence is pretty much locked
down since the last wave of spam attacks, but you can send a mail
with the article to the list, we'll publish it on the wiki.

Cheers
Andrea