My company is preparing to deploy an ArcGIS server. This is a long-term investment, so we want to make sure we don't start down the wrong path. We commonly use GIS in conjunction with other custom, web applications. In general, we much prefer to use PostgreSQL/Linux than Windows/SQL Server, but I don't know what kind of limitations ArcGIS server has in that environment, if any. Can someone give me a rundown of pros/cons, potential pitfalls, little-known facts about the two, etc.
Thank you much!