I have an existing PostGIS database that I use with QGIS. I am now looking at options for getting some of this data up on the web. Hence OpenGeo.
I have Geoserver installed and running and have succeeded in loading a simple layer from my PostGIS database. My current problem is that in QGIS/PostGIS I have used the base schema for my geometry tables and put all the tables relating to my layers into the layers schema. I build my layer using sql.
When I create a new 'store' in geoserver I am forced to specify a single schema within the database so this breaks my modus operandi that I use in QGIS.
I am also struggling to figure out how to define "SQL Views" and whether or not these are dependent on 'stores' or whether there is some other mechanism that will allow me to do arbitrarily complex SQL queries on the database.