[Geoserver-users] geoserver opening up many postgres connections

Doris_Lam · July 16, 2007, 6:18pm

Hi all,

I've been playing with geoserver and some test gps data, basically plotting them on google earth. I'm using geoserver 1.5.1, postgres 8.2.4 and postgis 1.2.1.
I've noticed that the first time I open google earth, it takes a very long time for the data to appear, but zooming in afterwards it was faster. But the speed would still vary. I just noticed, using ps -e, that I have about 45 postgres instances running. Is that normal (it's stopped spawning)?

Also, in google earth when I tried to see the 'states' that came with geoserver it shows a white overlay over the US instead of color coded. The same thing happens when I try to overlay polygons, for example, zip code outlines. If zoomed out it shows the outline correctly, but zoomed in everything becomes white. Does someone know what's the cause of this?

Thanks,
Doris

Justin_Deoliveira · July 16, 2007, 6:33pm

Hi Doris,

GeoServer has just recently drastically improved database connection management on the 1.6.x branch (trunk)... Unfortunately due the amount of effort involved it will not be back ported to the 1.5.x branch...

1.6 is currently in a beta state, with 1.6.0-beta2 just released. You can grab it here:

http://docs.codehaus.org/display/GEOS/Geoserver+1.6.0-beta2

-Justin

dlamoris@anonymised.com wrote:

Hi all,

I've been playing with geoserver and some test gps data, basically plotting them on google earth. I'm using geoserver 1.5.1, postgres 8.2.4 and postgis 1.2.1.
I've noticed that the first time I open google earth, it takes a very long time for the data to appear, but zooming in afterwards it was faster. But the speed would still vary. I just noticed, using ps -e, that I have about 45 postgres instances running. Is that normal (it's stopped spawning)?

Also, in google earth when I tried to see the 'states' that came with geoserver it shows a white overlay over the US instead of color coded. The same thing happens when I try to overlay polygons, for example, zip code outlines. If zoomed out it shows the outline correctly, but zoomed in everything becomes white. Does someone know what's the cause of this?

Thanks,
Doris

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,469bb68275394901796417!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

Justin_Deoliveira · July 16, 2007, 7:13pm

Hi Doris, missed your second question

Also, in google earth when I tried to see the 'states' that came with geoserver it shows a white overlay over the US instead of color coded. The same thing happens when I try to overlay polygons, for example, zip code outlines. If zoomed out it shows the outline correctly, but zoomed in everything becomes white. Does someone know what's the cause of this?

This is a bit strange... I have never seen this behavior before... what happens when you view the layer in the openlayers preview page... Do you notice the same problem at all?

Thanks,
Doris

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,469bb68275394901796417!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

Doris_Lam · July 16, 2007, 7:24pm

The map preview page looks ok, it's just that in google earth it's white..
for the states it looks like a white rectangle over US no matter what zoom level it is. I also have another table with zip code polygons that renders correctly at high altitude, but zoomed in it becomes white. The placemark circles are there though.

Also, I tried to shutdown geoserver using the shutdown script, but it says:

The GEOSERVER_HOME environment variable is not defined correctly
This environment variable is needed to run this program

I'm sure I set the env var: export GEOSERVER_HOME=/usr/local/geoserver
and then $GEOSERVER_HOME/bin/shutdown.sh
Am I missing something...?

Thanks,
Doris

Quoting Justin Deoliveira <jdeolive@anonymised.com>:

Hi Doris, missed your second question

Also, in google earth when I tried to see the 'states' that came with geoserver it shows a white overlay over the US instead of color coded. The same thing happens when I try to overlay polygons, for example, zip code outlines. If zoomed out it shows the outline correctly, but zoomed in everything becomes white. Does someone know what's the cause of this?

This is a bit strange... I have never seen this behavior before... what
happens when you view the layer in the openlayers preview page... Do
you notice the same problem at all?

Thanks,
Doris

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,469bb68275394901796417!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

Justin_Deoliveira · July 16, 2007, 7:27pm

What platform are you running on? Windows?

dlamoris@anonymised.com wrote:

The map preview page looks ok, it's just that in google earth it's white..
for the states it looks like a white rectangle over US no matter what zoom level it is. I also have another table with zip code polygons that renders correctly at high altitude, but zoomed in it becomes white. The placemark circles are there though.

Also, I tried to shutdown geoserver using the shutdown script, but it says:

The GEOSERVER_HOME environment variable is not defined correctly
This environment variable is needed to run this program

I'm sure I set the env var: export GEOSERVER_HOME=/usr/local/geoserver
and then $GEOSERVER_HOME/bin/shutdown.sh
Am I missing something...?

Thanks,
Doris

Quoting Justin Deoliveira <jdeolive@anonymised.com>:

Hi Doris, missed your second question

Also, in google earth when I tried to see the 'states' that came with geoserver it shows a white overlay over the US instead of color coded. The same thing happens when I try to overlay polygons, for example, zip code outlines. If zoomed out it shows the outline correctly, but zoomed in everything becomes white. Does someone know what's the cause of this?

This is a bit strange... I have never seen this behavior before... what
happens when you view the layer in the openlayers preview page... Do
you notice the same problem at all?

Thanks,
Doris

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,469bc5e7102861439371379!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

Doris_Lam · July 16, 2007, 7:36pm

Ubuntu 7

Quoting Justin Deoliveira <jdeolive@anonymised.com>:

What platform are you running on? Windows?

dlamoris@anonymised.com wrote:

The map preview page looks ok, it's just that in google earth it's white..
for the states it looks like a white rectangle over US no matter what zoom level it is. I also have another table with zip code polygons that renders correctly at high altitude, but zoomed in it becomes white. The placemark circles are there though.

Also, I tried to shutdown geoserver using the shutdown script, but it says:

The GEOSERVER_HOME environment variable is not defined correctly
This environment variable is needed to run this program

I'm sure I set the env var: export GEOSERVER_HOME=/usr/local/geoserver
and then $GEOSERVER_HOME/bin/shutdown.sh
Am I missing something...?

Thanks,
Doris

Quoting Justin Deoliveira <jdeolive@anonymised.com>:

Hi Doris, missed your second question

Also, in google earth when I tried to see the 'states' that came with geoserver it shows a white overlay over the US instead of color coded. The same thing happens when I try to overlay polygons, for example, zip code outlines. If zoomed out it shows the outline correctly, but zoomed in everything becomes white. Does someone know what's the cause of this?

This is a bit strange... I have never seen this behavior before... what
happens when you view the layer in the openlayers preview page... Do
you notice the same problem at all?

Thanks,
Doris

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

!DSPAM:4007,469bc5e7102861439371379!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

Justin_Deoliveira · July 16, 2007, 7:38pm

Ok... i am pretty sure this is a google earth linux problem... Chris is running ubuntu and having the same issue.. and i run gentoo and cant even add network links with google earth...

-Justin

dlamoris@anonymised.com wrote:

Ubuntu 7

Quoting Justin Deoliveira <jdeolive@anonymised.com>:

What platform are you running on? Windows?

dlamoris@anonymised.com wrote:

The map preview page looks ok, it's just that in google earth it's white...
for the states it looks like a white rectangle over US no matter what zoom level it is. I also have another table with zip code polygons that renders correctly at high altitude, but zoomed in it becomes white. The placemark circles are there though.

Also, I tried to shutdown geoserver using the shutdown script, but it says:

The GEOSERVER_HOME environment variable is not defined correctly
This environment variable is needed to run this program

I'm sure I set the env var: export GEOSERVER_HOME=/usr/local/geoserver
and then $GEOSERVER_HOME/bin/shutdown.sh
Am I missing something...?

Thanks,
Doris

Quoting Justin Deoliveira <jdeolive@anonymised.com>:

Hi Doris, missed your second question

Also, in google earth when I tried to see the 'states' that came with geoserver it shows a white overlay over the US instead of color coded. The same thing happens when I try to overlay polygons, for example, zip code outlines. If zoomed out it shows the outline correctly, but zoomed in everything becomes white. Does someone know what's the cause of this?

This is a bit strange... I have never seen this behavior before... what
happens when you view the layer in the openlayers preview page... Do
you notice the same problem at all?

Thanks,
Doris

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

This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

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

This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org

!DSPAM:4007,469bc8b9108327180515871!

--
Justin Deoliveira
The Open Planning Project
http://topp.openplans.org