Re: [udig-devel] Problem with PostGIS data

[Paul Ramsey <pramsey@xxxxxxxxxxxxxxx>]

select postgis_version();

However, your problem is pretty clearly w/ udig/geotools, some high 
level of evilness going on.

P

Robert Aldridge wrote:

> I'm having an issue in uDig accessing PostGIS layers. 
> I open uDig, create a new project and add 4 layers
> from my PostGis database.  After zooming in and
> panning around for a while, the layers stop rendering
> and I get the following in my postgresql logfile:
>
> LOG:  database system was shut down at 2005-04-21
> 14:32:27 CDT
> LOG:  checkpoint record is at 0/A67B240
> LOG:  redo record is at 0/A67B240; undo record is at
> 0/0; shutdown TRUE
> LOG:  next transaction ID: 34045; next OID: 171770
> LOG:  database system is ready
> LOG:  unexpected EOF on client connection
> FATAL:  sorry, too many clients already
> FATAL:  sorry, too many clients already
> FATAL:  sorry, too many clients already
> FATAL:  sorry, too many clients already
> FATAL:  sorry, too many clients already
>
> Any ideas?
>
> Thanks,
>
> Robert
>
> BTW, I'm running the following and apparently have the
> same issue with both uDig clients:
>
> * uDig 1.0.RC3 on Linux (the same box PostGIS is
> running on)
> * uDig 1.0.0 on WinXP accessing PostGIS on the Linux
> box)
> * PostgreSQL 7.4.2 on Linux
> * PostGIS (I'm not sure what version... Anyone know
> how to check PostGIS version in a running database?)
>
>
> 		
> __________________________________ 
> Do you Yahoo!? 
> Yahoo! Small Business - Try our new resources site!
> http://smallbusiness.yahoo.com/resources/ 
> _______________________________________________
> User-friendly Desktop Internet GIS (uDig)
> http://udig.refractions.net
> http://lists.refractions.net/mailman/listinfo/udig-devel