[postgis-users] Question about SDE on top of Postgres . . .

[Basques, Bob (CI-StPaul)]

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: postgis-users-bounces at lists.osgeo.org [mailto:postgis-users-
>  bounces at lists.osgeo.org] 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
>  <bladeoflight16 at gmail.com> wrote:
>  > On Fri, Oct 25, 2013 at 11:27 AM, Basques, Bob (CI-StPaul)
>  > <bob.basques at ci.stpaul.mn.us> 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
>  > postgis-users at lists.osgeo.org
>  > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>  _______________________________________________
>  postgis-users mailing list
>  postgis-users at lists.osgeo.org
>  http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users