Robert,

We are currently developing a site using the OpenGeo suite on a Windows 2008 server environment. True, the installation of OpenGeo does not allow much configuration options but we started with Geoserver and Postgres separately so have some details to share.

PostgreSQL and Geoserver were originally installed on two separate virtual servers. This worked perfectly well. I then installed the OpenGeo suite (primarily for GeoExplorer) on the same virtual server as the original Geoserver installation. Yes it installed an additional PostgreSQL database, but through the Geoserver that was installed with the OpenGeo suite I can point to the database on the other virtual server. PGAdmin and shp2postgis also can see the database on the other virtual server.

In summary, the installer is not just for testing purposes.

A suggestion also, shp2pgsql is a great tool but only allows one shapefile at a time. the SPIT plugin on QGIS allows multiple files to be imported to PostgreSQL.

Abe.

---------------------------------------------------------

On Wed, Oct 20, 2010 at 7:36 PM, Robert Buckley
<[email protected]> wrote:
> > Hi,
> >
> > Can anyone answer some questions related to opengeo and geoserver. I am looking > > for responses outside of the the opengeo forum which is why i?m posting here.
> >
> > I have been using geoserver for a good few months now and love it. I work for a > > large authority in germany. I have been using shapefiles until now, but would
> > like to use postgresql for added performance.
> >
> > I read about the opengeosuite in which there is the postgresql database already > > integrated into the setup but I think this is only for local installations and
> > not for server environments. The installation of postgresql doesn?t
> > automatically succeed and pgadmin and the shp2postgis loader only works locally. > > I therefore assume that this installer is only for testing purposes only and not
> > for server production environments.
> >
> > Can anyone confirm this?
> >
> > I basically just want the postgresql/postgis and geoserver part anyway, so would > > I be better off removing opengeosuite and installing geoserver and postgresql
> > separately?
> >
> > Any advice is much needed!!
> >
> > Thanks,
> >
> > Robert Buckley
--------------------------------------------------------------------


 Richard (Abe) Coughlin


   _OCEAN INFORMATION SYSTEMS SPECIALIST_
   *PACIOOS - Pacific Islands Ocean Observing System*
   Sea Grant College Program / University of Hawaii
   1-808-956-0822 [email protected]

------------------------------------------------------------------------------
Nokia and AT&T present the 2010 Calling All Innovators-North America contest
Create new apps & games for the Nokia N8 for consumers in  U.S. and Canada
$10 million total in prizes - $4M cash, 500 devices, nearly $6M in marketing
Develop with Nokia Qt SDK, Web Runtime, or Java and Publish to Ovi Store 
http://p.sf.net/sfu/nokia-dev2dev
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to