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

[George Silva]

I don't know the actual status of ArcSDE in 10.1, but in 9.3.1 they had
custom dlls (or .so) to do some sort of black magic.

I had a case where I needed to install ArcSDE with PostGIS 2.0, but ArcSDE
had to be 9.3.1 (32bits), without the support for that specific version.
Instead of using the 9.3.1 provided .so we used the 10.1 .so, which worked
just fine.

The problem, Paul, is not the client software, but the custom software that
needs to be inside the database machine.


On Mon, Oct 28, 2013 at 12:51 PM, Basques, Bob (CI-StPaul) <
bob.basques at ci.stpaul.mn.us> wrote:

> 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
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>



-- 
George R. C. Silva
SIGMA Consultoria
----------------------------
http://www.consultoriasigma.com.br/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131028/4eb2b06c/attachment.html>