Paul, Ours is all linux based (SUSE), so the windows part wasn't bothering me. There did seem to be a lot of steps to follow in order to make it work though. Our SDE folks are still settling on what to have in place as a DB. Oracle is the front runner, but I was hoping to be able to demonstrate PostGIS as an option. Just looking at options right now.
Bobb > -----Original Message----- > From: [email protected] [mailto:postgis-users- > [email protected]] On Behalf Of Paul Ramsey > Sent: Sunday, October 27, 2013 4:20 PM > To: PostGIS Users Discussion > Subject: Re: [postgis-users] Question about SDE on top of Postgres > . . . > > Wow, that page really goes out of its way to make sure you don't > want to use PostGIS! All those notes and caveats in the PostGIS > boxes! > > "Beginning with ArcGIS 10.1, all databases used with ArcGIS must > be 64-bit" WHAT?!?!? Client apps, by and large, don't give a damn > about what platform the database is running on. PgSQL in > particular speaks client/server in a protocol that doesn't care. > The only thing about PgSQL that would *have* to match the > architecture of ArcGIS is the client library (libpq.dll) and ESRI > will have built and bundled that into ArcGIS themselves using the > proper architecture. So, ignore all the items that say you can't > do Windows because there's no 64 bit build available: it'll work > fine. > > P. > > > > > > On Sat, Oct 26, 2013 at 6:18 PM, BladeOfLight16 > <[email protected]> wrote: > > On Fri, Oct 25, 2013 at 11:27 AM, Basques, Bob (CI-StPaul) > > <[email protected]> wrote: > >> > >> Sorry, I guess I should have looked just a little more before > posting > >> the question . . . . > >> > >> > >> > >> > http://support.esri.com/en/knowledgebase/techarticles/detail/40553 > > > > > > You may want to consider trying 9.1 with PostGIS 2.0 despite > what this > > documentation states. It says that the problem with 2.0 and > older > > clients is an incompatibility between PostGIS 2.0 and 1.5 > functions, > > but PostGIS 2.0 provides a legacy.sql. legacy.sql will create > the > > PostGIS 1.5 functions removed in 2.0. See > > http://postgis.net/docs/postgis_installation.html for > instructions on > > using legacy.sql. I realize this is not necessarily "officially" > > supported by ESRI, but I suspect it will work anyway. Probably > worth a try. > > > > _______________________________________________ > > postgis-users mailing list > > [email protected] > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
