|

»

Multiple instances of postgres.exe, Geoserver hangs

View: New views

5 Messages — Rating Filter: Alert me

	Multiple instances of postgres.exe, Geoserver hangs by GPS Blaster :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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 !
	RE: Multiple instances of postgres.exe, Geoserver hangs by craig.miller :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message I've seen this happen when the firewall isn't configured properly. The one time I saw it was after I installed ZoneAlarm. I'm not too big a fan of ZoneAlarm, so I just switched to my usual firewall and it immediately corrected the problem. --Craig -----Original Message----- From: postgis-users-bounces@... [mailto:postgis-users-bounces@...] On Behalf Of GPS Blaster Sent: Monday, July 31, 2006 1:06 AM To: postgis-users@... Subject: [postgis-users] Multiple instances of postgres.exe, Geoserver hangs 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 Sent from the PostGIS - User forum at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users
	Re: Multiple instances of postgres.exe, Geoserver hangs by elpepe-2 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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@...> 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 Sent from the PostGIS - User forum at Nabble.com. _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users
	Re: Multiple instances of postgres.exe, Geoserver hangs by Paul Ramsey :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message 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@... > <mailto:gps.blaster@...>> 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@... > <mailto:postgis-users@...> > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > ------------------------------------------------------------------------ > > _______________________________________________ > postgis-users mailing list > postgis-users@... > http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users
	Re: Multiple instances of postgres.exe, Geoserver hangs by Markus Schaber-7 :: Rate this Message: Reply to Author \| View Threaded \| Show Only this Message Hi, Paul, Hi, GPS Blaster, Paul Ramsey wrote: > 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. Depending on the PostgreSQL version and configuration, there are also some utility processes like the autovacuum daemon, the background writer and the statistics collector. PostgreSQL is optimized for long-living connections, wich can handle millions of transactions / user requests before being closed again. The maximum number of backend processes is set in the PostgreSQL configuration file. I don't know much about Geoserver, but maybe you can reconfigure it to use persistent connections, or use a pgpool instance inbetween. HTH, Markus -- Markus Schaber \| Logical Tracking&Tracing International AG Dipl. Inf. \| Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org _______________________________________________ postgis-users mailing list postgis-users@... http://postgis.refractions.net/mailman/listinfo/postgis-users