[postgis-users] Multiple instances of postgres.exe, Geoserver hangs

[Paul Ramsey]

That's the way PostgreSQL works, one process per connection, with shared 
memory segment for interprocess communications, plus one master process 
to create child processes as new connections come in.

P

Mario Servin wrote:
> Hi,
> I have noted in all versions of PostgreSQL (for Windows) that 
> always there is more than one instance of postgreql.exe running. Though 
> I have had no problem always catched my attention this strange 
> behavior..., does anybody know why is this happening?
> 
>  
> On 7/31/06, *GPS Blaster* <gps.blaster at gmail.com 
> <mailto:gps.blaster at gmail.com>> wrote:
> 
> 
>     Hi!
> 
>     We have a problem with Geoserver, PostGIS and MapBuilder.
> 
>     Our map displays fine, but we noticed a lot of instances of
>     postgres.exe in
>     the task manager, simultaneously, mapbuilder fails to refresh some
>     layers,
>     let's say street layer, that were showing, 20 or 30 seconds later
>     you pan
>     the map and then street layer are not anymore shown.
> 
>     We're not sure what causes the problem.
> 
>     Is Geoserver requesting too many connections? (we test it from only one
>     client and still dozens of postgres.exe instances)?
> 
>     Is Postgres.exe refusing more connections as a result of the many
>     instances?
> 
>     Could it be a driver / connector problem?
> 
>     Thanks !
>     --
>     View this message in context:
>     http://www.nabble.com/Multiple-instances-of-postgres.exe%2C-Geoserver-hangs-tf2026138.html#a5571600
>     <http://www.nabble.com/Multiple-instances-of-postgres.exe%2C-Geoserver-hangs-tf2026138.html#a5571600>
>     Sent from the PostGIS - User forum at Nabble.com <http://Nabble.com>.
> 
>     _______________________________________________
>     postgis-users mailing list
>     postgis-users at postgis.refractions.net
>     <mailto:postgis-users at postgis.refractions.net>
>     http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users