[Geoserver-devel] Geoserver

Mauricio_Lopez · December 13, 2005, 3:30pm

Hi everyone, I have seen that GeoServer works with MySQL and Postgresql, I wish your opinion, With which of these two databases, to geoserver works better with geographic data?
I try to handle with geoserver the cadastre of a whole region.
Regards.

Encuentra una aventura, un romance o al amor de tu vida. Date de alta gratis.

jive · December 13, 2005, 3:34pm

Mauricio Lopez wrote:

Hi everyone, I have seen that GeoServer works with MySQL and Postgresql, I wish your opinion, With which of these two databases, to geoserver works better with geographic data? I try to handle with geoserver the cadastre of a whole region.

PostGIS, and not just because Refractions sponsors it Much more time has been spent on PostGIS support w/ respect to conformance testing with CITE and optimization.

Jody

Justin_Deoliveira · December 13, 2005, 3:46pm

Definitley PostGIS. Postgis support in geotools is one of the better maintained and used modules so it is very stable. Not to knock MySQL, its just that postgres/postgis is very easy to install and use, which makes it very easy to support and test.

-Justin

Jody Garnett wrote:

Mauricio Lopez wrote:

Hi everyone, I have seen that GeoServer works with MySQL and Postgresql, I wish your opinion, With which of these two databases, to geoserver works better with geographic data? I try to handle with geoserver the cadastre of a whole region.

PostGIS, and not just because Refractions sponsors it Much more time has been spent on PostGIS support w/ respect to conformance testing with CITE and optimization.

Jody

-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

jive · December 13, 2005, 3:55pm

Justin Deoliveira wrote:

Definitley PostGIS. Postgis support in geotools is one of the better maintained and used modules so it is very stable. Not to knock MySQL, its just that postgres/postgis is very easy to install and use, which makes it very easy to support and test.

I will point out he is the PostGIS module maintainer

Justin_Deoliveira · December 13, 2005, 4:10pm

Darn, Jody caught me tooting on my own horn again. To my defense I have only been the module maintainer for about a month now and cant take credit for the robustness of the module :).

Jody Garnett wrote:

Justin Deoliveira wrote:

Definitley PostGIS. Postgis support in geotools is one of the better maintained and used modules so it is very stable. Not to knock MySQL, its just that postgres/postgis is very easy to install and use, which makes it very easy to support and test.

I will point out he is the PostGIS module maintainer

-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

Mauricio_Lopez · December 13, 2005, 6:09pm

Encuentra una aventura, un romance o al amor de tu vida. Date de alta gratis.

Mauricio_Lopez · December 13, 2005, 6:09pm

interesting, I am trying to create datastore for Postgresql 8,1, but there is an error:

ERROR: function postgis_version() does not exist

I have installed GeoServer 1.3 RC6, What more I need to install to support Postgresql 8.1?

Regards.

From: Jody Garnett jgarnett@anonymised.com
To: Justin Deoliveira jdeolive@anonymised.com
CC: Mauricio Lopez mauriciolopez32@anonymised.com ,geoserver-devel@lists.sourceforge.net
Subject: Re: [Geoserver-devel] Geoserver
Date: Tue, 13 Dec 2005 15:54:45 -0800

Justin Deoliveira wrote:

Definitley PostGIS. Postgis support in geotools is one of the
better maintained and used modules so it is very stable. Not to
knock MySQL, its just that postgres/postgis is very easy to install
and use, which makes it very easy to support and test.
I will point out he is the PostGIS module maintainer

Descubre la descarga digital segura. Medio millón de canciones en MSN Music.

Justin_Deoliveira · December 13, 2005, 5:10pm

It looks like you dont have postgis installed, in is an extension of postgres. Here are some docs.

http://postgis.refractions.net/documentation/

Mauricio Lopez wrote:

interesting, I am trying to create datastore for Postgresql 8,1, but there is an error:

ERROR: function postgis_version() does not exist

I have installed GeoServer 1.3 RC6, What more I need to install to support Postgresql 8.1?

Regards.

    ------------------------------------------------------------------------
    From: /Jody Garnett <jgarnett@anonymised.com>/
    To: /Justin Deoliveira <jdeolive@anonymised.com>/
    CC: /Mauricio Lopez
    <mauriciolopez32@anonymised.com>,geoserver-devel@lists.sourceforge.net/
    Subject: /Re: [Geoserver-devel] Geoserver/
    Date: /Tue, 13 Dec 2005 15:54:45 -0800/
     >Justin Deoliveira wrote:
     >>Definitley PostGIS. Postgis support in geotools is one of the
     >>better maintained and used modules so it is very stable. Not to
     >>knock MySQL, its just that postgres/postgis is very easy to install
     >>and use, which makes it very easy to support and test.
     >I will point out he is the PostGIS module maintainer

------------------------------------------------------------------------
Descubre la descarga digital segura. Medio millón de canciones en MSN Music. <http://g.msn.com/8HMAESES/2755??PS=47575>

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

Rob_Atkinson · December 13, 2005, 6:25pm

Hi Mauricio

To use linear geometries, you need to install PostGIS extensions.

To use point geometries, you can use the "Geometryless DataStore" option against a range of databases.

For more info see:
https://www.seegrid.csiro.au/twiki/bin/view/Infosrvices/GeometrylessJDBCDataStore

(The contents of this could be moved to the geotools wiki by someone with appropriate priveleges.)

Rob Atkinson

Mauricio Lopez wrote:

interesting, I am trying to create datastore for Postgresql 8,1, but there is an error:

ERROR: function postgis_version() does not exist

I have installed GeoServer 1.3 RC6, What more I need to install to support Postgresql 8.1?

Regards.

    From: /Jody Garnett <jgarnett@anonymised.com>/
    To: /Justin Deoliveira <jdeolive@anonymised.com>/
    CC: /Mauricio Lopez
    <mauriciolopez32@anonymised.com>,geoserver-devel@lists.sourceforge.net/
    Subject: /Re: [Geoserver-devel] Geoserver/
    Date: /Tue, 13 Dec 2005 15:54:45 -0800/
    >Justin Deoliveira wrote:
    >>Definitley PostGIS. Postgis support in geotools is one of the
    >>better maintained and used modules so it is very stable. Not to
    >>knock MySQL, its just that postgres/postgis is very easy to install
    >>and use, which makes it very easy to support and test.
    >I will point out he is the PostGIS module maintainer

Descubre la descarga digital segura. Medio millón de canciones en MSN Music. <http://g.msn.com/8HMAESES/2755??PS=47575> ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click _______________________________________________ Geoserver-devel mailing list Geoserver-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-devel

Chris_Holmes1 · December 14, 2005, 12:33am

Quoting Rob Atkinson <rob@anonymised.com>:

Hi Mauricio

To use linear geometries, you need to install PostGIS extensions.

To use point geometries, you can use the "Geometryless DataStore"
option
against a range of databases.

For more info see:

https://www.seegrid.csiro.au/twiki/bin/view/Infosrvices/GeometrylessJDBCDataStore

(The contents of this could be moved to the geotools wiki by someone
with appropriate priveleges.)

Everyone has appropriate priveleges, you just need to sign up for a
confluence account, put your email and password. Would be nice to have
information in the geoserver wiki as well.

Also Mauricio, if you're using Windows the postgresql installer has an
option for PostGIS, it's not on by defualt, but you just need to click
it and you'll be set up.

Chris

Rob Atkinson

Mauricio Lopez wrote:
>
> interesting, I am trying to create datastore for Postgresql 8,1,
but
> there is an error:
>
> ERROR: function postgis_version() does not exist
>
> I have installed GeoServer 1.3 RC6, What more I need to install to
> support Postgresql 8.1?
>
> Regards.
>
>
>
>
>
> From: /Jody Garnett <jgarnett@anonymised.com>/
> To: /Justin Deoliveira <jdeolive@anonymised.com>/
> CC: /Mauricio Lopez
>
<mauriciolopez32@anonymised.com>,geoserver-devel@lists.sourceforge.net/
> Subject: /Re: [Geoserver-devel] Geoserver/
> Date: /Tue, 13 Dec 2005 15:54:45 -0800/
> >Justin Deoliveira wrote:
> >>Definitley PostGIS. Postgis support in geotools is one of the
> >>better maintained and used modules so it is very stable. Not
to
> >>knock MySQL, its just that postgres/postgis is very easy to
install
> >>and use, which makes it very easy to support and test.
> >I will point out he is the PostGIS module maintainer
>
>
> Descubre la descarga digital segura. Medio millón de canciones en
MSN
> Music. <http://g.msn.com/8HMAESES/2755??PS=47575>
> ------------------------------------------------------- This SF.net
> email is sponsored by: Splunk Inc. Do you grep through log files
for
> problems? Stop! Download the new AJAX search engine that makes
> searching your log files as easy as surfing the web. DOWNLOAD
SPLUNK!
> http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
> _______________________________________________ Geoserver-devel
> mailing list Geoserver-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-devel

-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through
log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD
SPLUNK!
http://ads.osdn.com/?ad_id=7637&alloc_id=16865&op=click
_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

----------------------------------------------------------
This mail sent through IMP: https://webmail.limegroup.com/