Gary, I haven't done a lot with "web GIS" so take what I am about to say with several grains of salt. :]
If you aren't using PostgreSQL right now, but will be after the move to Linux, I think this is a definite improvement. PostgreSQL is the most advanced open source database that I have found, and nothing in the open source world beats PostGIS for "spatially enabling" a database. I looked into this some months ago. I didn't find any other open source database, not even MySQL, that allowed for customization and tweaking like PostgreSQL did. Besides, the folks at Refractions Research, who maintain PostGIS, are quite helpful. Also, if you will be starting out with PostgreSQL and Linux some of my old notes might be helpful: http://bluwiki.com/go/PostgreSQL_Tips_From_The_Sunburned_Surveyor Landon P.S. - You can use PostgreSQL and PostGIS on MS Windows of course, but it would be an advantage of moving to Linux. PostGIS is really an extension to PostgreSQL, not a "front end". If you are looking for a graphical front end to PostGIS that you can use as an administrator, check out pgAdminIII. http://www.pgadmin.org/ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gary Watry Sent: Tuesday, June 19, 2007 11:57 AM To: UMN-List-Serve *****; [EMAIL PROTECTED] Subject: [OSGeo-Discuss] Windows verse Linux Hi everyone I need advice from the experts I am running Windows Server 2003 with Apache and Mapserver. I currently have 9 sites running Mapserver The Center wants to move to Linux from SGI I want to run Mapserver with dbox (Steve, dbox run on Linux?) Mapserver as WMS feed to MapBuilder. On the database side is it 1. PostGIS or PostgreSQL 2. PostGIS and PostgreSQL (think I have to run PostGIS as front to PostgreSQL). Question: What do I gain by going to Linux? What do I gain by staying in a Windows Environment? Any thoughts appreciated! -------------------------------------------- The information transmitted is intended solely for the person or entity for which it is addressed and may contain confidential and/or privileged information. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this email in error, please contact the sender and delete the material from your computer. ____________________________________________ Gary L. Watry GIS Coordinator Center for Ocean-Atmospheric Prediction Studies FSU / COAPS Johnson Building, RM 215 2035 East Paul Dirac Drive Tallahassee, Florida 32306-2840 Phone (850) 645-7457 E-Mail: [EMAIL PROTECTED] _______________________________________________ Discuss mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/discuss Warning: Information provided via electronic media is not guaranteed against defects including translation and transmission errors. If the reader is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this information in error, please notify the sender immediately. _______________________________________________ Discuss mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/discuss
