[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Question about SDE on top of Postgres . . .
From: George Silva <georger.silva () gmail ! com>
Date: 2013-10-28 14:58:50
Message-ID: CAGyPVTuJzNy37JNBudeDV_wBpR5hEX1c8btOK50=w4r9mY2pGw () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
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@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@lists.osgeo.org [mailto:postgis-users-
> > bounces@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@gmail.com> wrote:
> > > On Fri, Oct 25, 2013 at 11:27 AM, Basques, Bob (CI-StPaul)
> > > <bob.basques@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@lists.osgeo.org
> > > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users@lists.osgeo.org
> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
--
George R. C. Silva
SIGMA Consultoria
----------------------------
http://www.consultoriasigma.com.br/
[Attachment #5 (text/html)]
<div dir="ltr">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.<div><br></div><div>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.</div>
<div><br></div><div>The problem, Paul, is not the client software, but the custom \
software that needs to be inside the database machine.</div></div><div \
class="gmail_extra"><br><br><div class="gmail_quote">On Mon, Oct 28, 2013 at 12:51 \
PM, Basques, Bob (CI-StPaul) <span dir="ltr"><<a \
href="mailto:bob.basques@ci.stpaul.mn.us" \
target="_blank">bob.basques@ci.stpaul.mn.us</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">Paul,<br> <br>
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.<br>
<br>
Bobb<br>
<div class="im HOEnZb"><br>
<br>
<br>
> -----Original Message-----<br>
> From: <a href="mailto:postgis-users-bounces@lists.osgeo.org">postgis-users-bounces@lists.osgeo.org</a> \
[mailto:<a href="mailto:postgis-users-">postgis-users-</a><br> > <a \
href="mailto:bounces@lists.osgeo.org">bounces@lists.osgeo.org</a>] On Behalf Of Paul \
Ramsey<br> > Sent: Sunday, October 27, 2013 4:20 PM<br>
> To: PostGIS Users Discussion<br>
> Subject: Re: [postgis-users] Question about SDE on top of Postgres<br>
> . . .<br>
><br>
</div><div class="HOEnZb"><div class="h5">> Wow, that page really goes out of its \
way to make sure you don't<br> > want to use PostGIS! All those notes and \
caveats in the PostGIS<br> > boxes!<br>
><br>
> "Beginning with ArcGIS 10.1, all databases used with ArcGIS must<br>
> be 64-bit" WHAT?!?!? Client apps, by and large, don't give a damn<br>
> about what platform the database is running on. PgSQL in<br>
> particular speaks client/server in a protocol that doesn't care.<br>
> The only thing about PgSQL that would *have* to match the<br>
> architecture of ArcGIS is the client library (libpq.dll) and ESRI<br>
> will have built and bundled that into ArcGIS themselves using the<br>
> proper architecture. So, ignore all the items that say you can't<br>
> do Windows because there's no 64 bit build available: it'll work<br>
> fine.<br>
><br>
> P.<br>
><br>
><br>
><br>
><br>
><br>
> On Sat, Oct 26, 2013 at 6:18 PM, BladeOfLight16<br>
> <<a href="mailto:bladeoflight16@gmail.com">bladeoflight16@gmail.com</a>> \
wrote:<br> > > On Fri, Oct 25, 2013 at 11:27 AM, Basques, Bob (CI-StPaul)<br>
> > <<a href="mailto:bob.basques@ci.stpaul.mn.us">bob.basques@ci.stpaul.mn.us</a>> \
wrote:<br> > >><br>
> >> Sorry, I guess I should have looked just a little more before<br>
> posting<br>
> >> the question . . . .<br>
> >><br>
> >><br>
> >><br>
> >><br>
> <a href="http://support.esri.com/en/knowledgebase/techarticles/detail/40553" \
target="_blank">http://support.esri.com/en/knowledgebase/techarticles/detail/40553</a><br>
> ><br>
> ><br>
> > You may want to consider trying 9.1 with PostGIS 2.0 despite<br>
> what this<br>
> > documentation states. It says that the problem with 2.0 and<br>
> older<br>
> > clients is an incompatibility between PostGIS 2.0 and 1.5<br>
> functions,<br>
> > but PostGIS 2.0 provides a legacy.sql. legacy.sql will create<br>
> the<br>
> > PostGIS 1.5 functions removed in 2.0. See<br>
> > <a href="http://postgis.net/docs/postgis_installation.html" \
target="_blank">http://postgis.net/docs/postgis_installation.html</a> for<br> > \
instructions on<br> > > using legacy.sql. I realize this is not necessarily \
"officially"<br> > > supported by ESRI, but I suspect it will work \
anyway. Probably<br> > worth a try.<br>
> ><br>
> > _______________________________________________<br>
> > postgis-users mailing list<br>
> > <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> > <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
> _______________________________________________<br> > postgis-users mailing \
list<br> > <a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
<br> <br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br> \
</div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div \
dir="ltr">George R. C. Silva<br>SIGMA \
Consultoria<div>----------------------------<br><div><a \
href="http://www.consultoriasigma.com.br/" \
target="_blank">http://www.consultoriasigma.com.br/</a><div \
style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%">
</div><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap \
:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div><div \
style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%">
</div></div></div></div>
</div>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic