Re: [Geoserver-users] GetCapabilities (& other requests) very slow for time-enabled PostGIS layers

2013-08-12 Thread Justin Deoliveira
Great, thanks Mike. That definitely narrows it down. Looks like we need to
update the wrapper that comes into play when renaming to pass down the
function natively. Do you mind opening a jira ticket for this? Thanks.


On Mon, Aug 12, 2013 at 10:44 AM, Mike Grogan wrote:

> Justin,
>
> Yes, the layer name does seem to be causing an issue.  To clarify, this is
> for the NON-SQL-VIEW layer.  The underlying postgis table is "latest", as
> is the name of the store.
>
> If I name the layer "latest" in Geoserver "Edit Layer", I see the
> following query upon a GetCapabilities:
>
> 12 Aug 16:36:08 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
> 12 Aug 16:36:08 DEBUG [org.geotools.jdbc] - SELECT distinct("timestamp")
> FROM "public"."latest"
> 12 Aug 16:36:09 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
>
> If I rename the layer in Geoserver to something else ... "latestxxx",
> while leaving the postgis layer & store as "latest", I see the following
> query:
>
> 12 Aug 16:37:09 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
> 12 Aug 16:37:09 DEBUG [org.geotools.jdbc] - SELECT "timestamp" FROM
> "public"."latest"
> 12 Aug 16:37:16 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION
>
> So, the distinct() aggregate does seem to be disappearing if the layer
> name is not the same as the store/table name.
>
> Hope this helps, and thanks for looking at this.
>
> - Mike
>
>
>
>
>
> On Mon, Aug 12, 2013 at 12:01 PM, Justin Deoliveira 
> wrote:
>
>> The changes I made where indeed backported to 9.x.
>>
>>   https://github.com/geotools/geotools/pull/195
>>   http://jira.codehaus.org/browse/GEOT-4457
>>
>> They should have been released for geotools 9.3 which i believe would
>> have made it into geoserver 2.3.3?
>>
>> So it may be in this case there is an intermediate wrapper being used
>> that we are not accounting for. One thing that comes to mind might be a
>> layer renaming.
>>
>> @Mike: What is the published layer name (ie the layer you request from
>> geoserver) in this case? Is it called "latest". If the published layer is
>> not named "latest" can you try temporarily renaming it to "latest" and see
>> if that affects anything.
>>
>>
>>
>>
>> On Fri, Aug 9, 2013 at 8:49 AM, Mike Grogan 
>> wrote:
>>
>>> Thanks, Andrea and Justin.  I'm not quite following the flow of the code
>>> yet, but trying.  If Justin has a chance to review my description and log
>>> excerpts at some point, that would be great, too.  I appreciate your
>>> response.
>>>
>>> - Mike Grogan
>>>
>>>
>>> On Thu, Aug 8, 2013 at 1:45 PM, Andrea Aime <
>>> andrea.a...@geo-solutions.it> wrote:
>>>
 On Thu, Aug 8, 2013 at 7:28 PM, Mike Grogan >>> > wrote:

> Can anyone point me to the point in the source where these queries are
> made to determine the times for the time dimensions for WMS 
> GetCapabilities
> and postgis stores?  The problem described in my earlier post continues to
> perplex me ... and I can't find the location in the source to look for
> myself.  I have tried!
>

 GeoServer code almost never knows about the nature of the underlying
 storage, it uses the GeoTools API
 to access data, in this case, it's using a UniqueVisitor if possible
 (or a min/max one depending on the representation type):


 https://github.com/geoserver/geoserver/blob/master/src/wms/src/main/java/org/geoserver/wms/WMS.java#L947

 This in turn should lead to the encoding of a aggregate function here:


 https://github.com/geotools/geotools/blob/master/modules/library/jdbc/src/main/java/org/geotools/jdbc/JDBCDataStore.java#L1279

 However, there might be some hiccups in the intermediary classes
 between the first and the second code bits,
 maybe a wrapper that does reprojection, crs forcing or something like
 that misses the appropriate delegation.
 Which is actually something Justin (cc'ed) tried to fix some time ago,
 but not sure in which branch that work landed?
 It might be that 2.4 beta does not exhibit this problem anymore.

 Cheers
 Andrea


 --
 ==
 Our support, Your Success! Visit http://opensdi.geo-solutions.it for
 more information.
 ==

 Ing. Andrea Aime
 @geowolf
 Technical Lead

 GeoSolutions S.A.S.
 Via Poggio alle Viti 1187
 55054  Massarosa (LU)
 Italy
 phone: +39 0584 962313
 fax: +39 0584 1660272
 mob: +39  339 8844549

 http://www.geo-solutions.it
 http://twitter.com/geosolutions_it

 ---

>>>
>>>
>>
>>
>> --
>> Justin Deoliveira
>> OpenGeo - http://opengeo.org
>> Enterprise support for open source geospatial.
>>
>
>


-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshoot

Re: [Geoserver-users] GetCapabilities (& other requests) very slow for time-enabled PostGIS layers

2013-08-12 Thread Mike Grogan
Justin,

Yes, the layer name does seem to be causing an issue.  To clarify, this is
for the NON-SQL-VIEW layer.  The underlying postgis table is "latest", as
is the name of the store.

If I name the layer "latest" in Geoserver "Edit Layer", I see the following
query upon a GetCapabilities:

12 Aug 16:36:08 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
12 Aug 16:36:08 DEBUG [org.geotools.jdbc] - SELECT distinct("timestamp")
FROM "public"."latest"
12 Aug 16:36:09 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION

If I rename the layer in Geoserver to something else ... "latestxxx", while
leaving the postgis layer & store as "latest", I see the following query:

12 Aug 16:37:09 DEBUG [org.geotools.jdbc] - CREATE CONNECTION
12 Aug 16:37:09 DEBUG [org.geotools.jdbc] - SELECT "timestamp" FROM
"public"."latest"
12 Aug 16:37:16 DEBUG [org.geotools.jdbc] - CLOSE CONNECTION

So, the distinct() aggregate does seem to be disappearing if the layer name
is not the same as the store/table name.

Hope this helps, and thanks for looking at this.

- Mike





On Mon, Aug 12, 2013 at 12:01 PM, Justin Deoliveira wrote:

> The changes I made where indeed backported to 9.x.
>
>   https://github.com/geotools/geotools/pull/195
>   http://jira.codehaus.org/browse/GEOT-4457
>
> They should have been released for geotools 9.3 which i believe would have
> made it into geoserver 2.3.3?
>
> So it may be in this case there is an intermediate wrapper being used that
> we are not accounting for. One thing that comes to mind might be a layer
> renaming.
>
> @Mike: What is the published layer name (ie the layer you request from
> geoserver) in this case? Is it called "latest". If the published layer is
> not named "latest" can you try temporarily renaming it to "latest" and see
> if that affects anything.
>
>
>
>
> On Fri, Aug 9, 2013 at 8:49 AM, Mike Grogan wrote:
>
>> Thanks, Andrea and Justin.  I'm not quite following the flow of the code
>> yet, but trying.  If Justin has a chance to review my description and log
>> excerpts at some point, that would be great, too.  I appreciate your
>> response.
>>
>> - Mike Grogan
>>
>>
>> On Thu, Aug 8, 2013 at 1:45 PM, Andrea Aime > > wrote:
>>
>>> On Thu, Aug 8, 2013 at 7:28 PM, Mike Grogan 
>>> wrote:
>>>
 Can anyone point me to the point in the source where these queries are
 made to determine the times for the time dimensions for WMS GetCapabilities
 and postgis stores?  The problem described in my earlier post continues to
 perplex me ... and I can't find the location in the source to look for
 myself.  I have tried!

>>>
>>> GeoServer code almost never knows about the nature of the underlying
>>> storage, it uses the GeoTools API
>>> to access data, in this case, it's using a UniqueVisitor if possible (or
>>> a min/max one depending on the representation type):
>>>
>>>
>>> https://github.com/geoserver/geoserver/blob/master/src/wms/src/main/java/org/geoserver/wms/WMS.java#L947
>>>
>>> This in turn should lead to the encoding of a aggregate function here:
>>>
>>>
>>> https://github.com/geotools/geotools/blob/master/modules/library/jdbc/src/main/java/org/geotools/jdbc/JDBCDataStore.java#L1279
>>>
>>> However, there might be some hiccups in the intermediary classes between
>>> the first and the second code bits,
>>> maybe a wrapper that does reprojection, crs forcing or something like
>>> that misses the appropriate delegation.
>>> Which is actually something Justin (cc'ed) tried to fix some time ago,
>>> but not sure in which branch that work landed?
>>> It might be that 2.4 beta does not exhibit this problem anymore.
>>>
>>> Cheers
>>> Andrea
>>>
>>>
>>> --
>>> ==
>>> Our support, Your Success! Visit http://opensdi.geo-solutions.it for
>>> more information.
>>> ==
>>>
>>> Ing. Andrea Aime
>>> @geowolf
>>> Technical Lead
>>>
>>> GeoSolutions S.A.S.
>>> Via Poggio alle Viti 1187
>>> 55054  Massarosa (LU)
>>> Italy
>>> phone: +39 0584 962313
>>> fax: +39 0584 1660272
>>> mob: +39  339 8844549
>>>
>>> http://www.geo-solutions.it
>>> http://twitter.com/geosolutions_it
>>>
>>> ---
>>>
>>
>>
>
>
> --
> Justin Deoliveira
> OpenGeo - http://opengeo.org
> Enterprise support for open source geospatial.
>
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] GetCapabilities (& other requests) very slow for time-enabled PostGIS layers

2013-08-12 Thread Justin Deoliveira
The changes I made where indeed backported to 9.x.

  https://github.com/geotools/geotools/pull/195
  http://jira.codehaus.org/browse/GEOT-4457

They should have been released for geotools 9.3 which i believe would have
made it into geoserver 2.3.3?

So it may be in this case there is an intermediate wrapper being used that
we are not accounting for. One thing that comes to mind might be a layer
renaming.

@Mike: What is the published layer name (ie the layer you request from
geoserver) in this case? Is it called "latest". If the published layer is
not named "latest" can you try temporarily renaming it to "latest" and see
if that affects anything.




On Fri, Aug 9, 2013 at 8:49 AM, Mike Grogan wrote:

> Thanks, Andrea and Justin.  I'm not quite following the flow of the code
> yet, but trying.  If Justin has a chance to review my description and log
> excerpts at some point, that would be great, too.  I appreciate your
> response.
>
> - Mike Grogan
>
>
> On Thu, Aug 8, 2013 at 1:45 PM, Andrea Aime 
> wrote:
>
>> On Thu, Aug 8, 2013 at 7:28 PM, Mike Grogan 
>> wrote:
>>
>>> Can anyone point me to the point in the source where these queries are
>>> made to determine the times for the time dimensions for WMS GetCapabilities
>>> and postgis stores?  The problem described in my earlier post continues to
>>> perplex me ... and I can't find the location in the source to look for
>>> myself.  I have tried!
>>>
>>
>> GeoServer code almost never knows about the nature of the underlying
>> storage, it uses the GeoTools API
>> to access data, in this case, it's using a UniqueVisitor if possible (or
>> a min/max one depending on the representation type):
>>
>>
>> https://github.com/geoserver/geoserver/blob/master/src/wms/src/main/java/org/geoserver/wms/WMS.java#L947
>>
>> This in turn should lead to the encoding of a aggregate function here:
>>
>>
>> https://github.com/geotools/geotools/blob/master/modules/library/jdbc/src/main/java/org/geotools/jdbc/JDBCDataStore.java#L1279
>>
>> However, there might be some hiccups in the intermediary classes between
>> the first and the second code bits,
>> maybe a wrapper that does reprojection, crs forcing or something like
>> that misses the appropriate delegation.
>> Which is actually something Justin (cc'ed) tried to fix some time ago,
>> but not sure in which branch that work landed?
>> It might be that 2.4 beta does not exhibit this problem anymore.
>>
>> Cheers
>> Andrea
>>
>>
>> --
>> ==
>> Our support, Your Success! Visit http://opensdi.geo-solutions.it for
>> more information.
>> ==
>>
>> Ing. Andrea Aime
>> @geowolf
>> Technical Lead
>>
>> GeoSolutions S.A.S.
>> Via Poggio alle Viti 1187
>> 55054  Massarosa (LU)
>> Italy
>> phone: +39 0584 962313
>> fax: +39 0584 1660272
>> mob: +39  339 8844549
>>
>> http://www.geo-solutions.it
>> http://twitter.com/geosolutions_it
>>
>> ---
>>
>
>


-- 
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


[Geoserver-users] Restrict admin user to specific workspace

2013-08-12 Thread Paul Meems
I have a default Geoserver v2.2.1 setup, which I use for demo purposes.

I'm now working on a project that requires a second user to work on my
Geoserver.
I want this second user admin rights to a specific workspace only, so he
can add, remove and alter layers and stores.

I've created a new Group Servers using the 'Users, Groups, and Roles' page.
In this service I've added a new user.

In the 'Data Security' page I've added a rule: .*.a

Now I don't know how to continue. I've looked at the Group options and the
Role options but I'm not sure how to add the data rule to the new user.

Can anybody assist?

Thanks,

Paul
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] the 'right' place to inform HTTP Users

2013-08-12 Thread Jonathan Moules
Hi Terry,
  GeoServer has some ability to set header caches.
http://docs.geoserver.org/stable/en/user/geowebcache/responseheaders.htmlmay
be of interest though I've not dabbled with that aspect.

To set headers in GeoServer it needs to be done on a per-layer basis
unfortunately-
http://docs.geoserver.org/stable/en/user/webadmin/data/layers.html?highlight=http%20cache%20header#edit-publishing-information

If you set the timeout for 43000 (~12hrs), that should ensure anything that
is cached is wiped out next day; it's unlikely many users will be doing
13hr days. :-)

As noted, this must be done on a per-layer basis. I opened a JIRA
improvement a few months back suggesting a universal default -
http://jira.codehaus.org/browse/GEOS-5833 - We've not sponsored it
ourselves, but you're welcome to if you wish.

I have no idea about WFS or how that is cached if at all (per client
rules?).

Cheers,
Jonathan



On 12 August 2013 09:25, Terry Rankine  wrote:

> Hi Guys
>
> Where is the 'right place' to let users know that out data changes each
> night?
>
> We have a WFS on top of our dataset, and each night we slurp in updates
> from
> other providers. Can we configure Geoserver to help us tell out
> 'subscribers' how long our data is valid for?
>
> Can geoserver set a HTTP header telling caches up/downstream how long to
> keep the data for - or when it expires?
>
> Is this something that belongs in Geoserver or outside Geoserver?
>
> Geoserver already enables us to use GWC for WMS - but how do we let GWC
> know
> that our data is 'valid for the entire day' until midnight when it
> changes each night?
>
> While I am happy to just tell the bunch of users we know about using
> various
> methods (email, metadata, etc) What about the ones we dont personally know?
> Is there a way of using HTTP headers more effectively here - and 'which
> system' in the big picture should be responsible for that? Geoserver?
> External Cache?
>
> Is anyone else using HTTP Headers to inform users how long the data is
> valid
> for?
>
> Regards,
> Terry Rankine
>
>
>
> --
> View this message in context:
> http://osgeo-org.1560.x6.nabble.com/the-right-place-to-inform-HTTP-Users-tp5072007.html
> Sent from the GeoServer - User mailing list archive at Nabble.com.
>
>
> --
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>

-- 
This transmission is intended for the named addressee(s) only and may 
contain sensitive or protectively marked material up to RESTRICTED and 
should be handled accordingly. Unless you are the named addressee (or 
authorised to receive it for the addressee) you may not copy or use it, or 
disclose it to anyone else. If you have received this transmission in error 
please notify the sender immediately. All email traffic sent to or from us, 
including without limitation all GCSX traffic, may be subject to recording 
and/or monitoring in accordance with relevant legislation.
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] GeoServer cluster running against PostGIS cluster

2013-08-12 Thread Jonathan Moules
Hi,
This blog post by Simone explains how they did it for very high
availability:
http://geo-solutions.blogspot.it/2012/08/real-world-uses-cases-troubleshooting.html

This also may be of interest -
http://suite.opengeo.org/opengeo-docs/sysadmin/production/availability.html

Jonathan



On 12 August 2013 08:14, Hakala Oiva (MTT)  wrote:

> Hi,
>
> I am not an advanced Geoserver user, but I have managed to use 2 Geoserver
> instances, but that is not any limit. I used Iacovella - Younblood
> "Geoserver's Beginners Guide" to configure a simple Geoserver cluster. I
> also use one PostGis instance. Using more Postgis instances may not be so
> easy. I think more than one database servers are needed, and every server
> needs a Geoserver store of it's own.
>
> Oiva Hakala
> Agrifood Research Finland
>
>
>
> 
> Lähettäjä: Darren Hardy [d...@stanford.edu]
> Lähetetty: 9. elokuuta 2013 21:26
> Vastaanottaja: Geoserver
> Aihe: [Geoserver-users] GeoServer cluster running against PostGIS cluster
>
> Hi,
>
> What is the most common way to cluster both the GeoServer instances and
> the PostGIS instances for high availability? The user documentation doesn't
> seem to indicate how to create clustered database connection pools from
> GeoServer to PostGIS. The examples I've seen have a single GeoServer
> instance pairs with a single PostGIS instance.
>
> Thanks,
> -Darren
> --
>  Darren Hardy
>  Digital Library Systems & Services
>  Stanford University
>
> --
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>
>
> --
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> ___
> Geoserver-users mailing list
> Geoserver-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>

-- 
This transmission is intended for the named addressee(s) only and may 
contain sensitive or protectively marked material up to RESTRICTED and 
should be handled accordingly. Unless you are the named addressee (or 
authorised to receive it for the addressee) you may not copy or use it, or 
disclose it to anyone else. If you have received this transmission in error 
please notify the sender immediately. All email traffic sent to or from us, 
including without limitation all GCSX traffic, may be subject to recording 
and/or monitoring in accordance with relevant legislation.
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


[Geoserver-users] the 'right' place to inform HTTP Users

2013-08-12 Thread Terry Rankine
Hi Guys

Where is the 'right place' to let users know that out data changes each
night?

We have a WFS on top of our dataset, and each night we slurp in updates from
other providers. Can we configure Geoserver to help us tell out
'subscribers' how long our data is valid for?

Can geoserver set a HTTP header telling caches up/downstream how long to
keep the data for - or when it expires?

Is this something that belongs in Geoserver or outside Geoserver? 

Geoserver already enables us to use GWC for WMS - but how do we let GWC know
that our data is 'valid for the entire day' until midnight when it
changes each night?

While I am happy to just tell the bunch of users we know about using various
methods (email, metadata, etc) What about the ones we dont personally know?
Is there a way of using HTTP headers more effectively here - and 'which
system' in the big picture should be responsible for that? Geoserver?
External Cache? 

Is anyone else using HTTP Headers to inform users how long the data is valid
for?

Regards,
Terry Rankine



--
View this message in context: 
http://osgeo-org.1560.x6.nabble.com/the-right-place-to-inform-HTTP-Users-tp5072007.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] GeoServer cluster running against PostGIS cluster

2013-08-12 Thread Hakala Oiva (MTT)
Eh, the book is Iacovella - Youngblood: "Geoserver Beginner's Guide".

Oiva

Hi,

What is the most common way to cluster both the GeoServer instances and the 
PostGIS instances for high availability? The user documentation doesn't seem to 
indicate how to create clustered database connection pools from GeoServer to 
PostGIS. The examples I've seen have a single GeoServer instance pairs with a 
single PostGIS instance.

Thanks,
-Darren
--
 Darren Hardy
 Digital Library Systems & Services
 Stanford University

--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users


Re: [Geoserver-users] GeoServer cluster running against PostGIS cluster

2013-08-12 Thread Hakala Oiva (MTT)
Hi,

I am not an advanced Geoserver user, but I have managed to use 2 Geoserver 
instances, but that is not any limit. I used Iacovella - Younblood "Geoserver's 
Beginners Guide" to configure a simple Geoserver cluster. I also use one 
PostGis instance. Using more Postgis instances may not be so easy. I think more 
than one database servers are needed, and every server needs a Geoserver store 
of it's own.

Oiva Hakala
Agrifood Research Finland




Lähettäjä: Darren Hardy [d...@stanford.edu]
Lähetetty: 9. elokuuta 2013 21:26
Vastaanottaja: Geoserver
Aihe: [Geoserver-users] GeoServer cluster running against PostGIS cluster

Hi,

What is the most common way to cluster both the GeoServer instances and the 
PostGIS instances for high availability? The user documentation doesn't seem to 
indicate how to create clustered database connection pools from GeoServer to 
PostGIS. The examples I've seen have a single GeoServer instance pairs with a 
single PostGIS instance.

Thanks,
-Darren
--
 Darren Hardy
 Digital Library Systems & Services
 Stanford University
--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead. 
Download for free and get started troubleshooting in minutes. 
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
___
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users