ArcCatalog interface to PostgeSql question - Mailing list pgsql-interfaces

From Clay, Bruce
Subject ArcCatalog interface to PostgeSql question
Date
Msg-id C482FF98AE985A47B8C982FD429C9E344F2594@daytonmsg2k3.AERO.BALL.COM
Whole thread Raw
List pgsql-interfaces
<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I have seen mention of a way to interface ArcCatalog or ArcMap with PostgreSql but I can not find
anydetails.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I am using PostgreSql 8.1 and have tried to set up ArcCatalog by way of “Add OLE DB Connection” and
“AddSpatial Database Connection” but can not get things to work</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">When I try “OLE DB Connection” I see PostgreSql OLE DB as a provider in the list of options but I
can’tfind anything that says what to use for “Data Source” nor “Location” parameters.  I tried “localhost” as the
locationbut got a “Test connection failed because of an error in initializing provider. Unspecified error”
message.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">When I try “Add Spatial Database Connection” I get an error message (Failed to connect to specified
server)from ArcCatalog and the postgreSql logs show the following:</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal" style="text-autospace:none"><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">2005-05-03 </span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">14:12:43</span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New""> LOG:  database system was shut down at 2005-05-03
</span></font><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier
New"">14:12:06</span></font><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"">
EasternStandard Time</span></font><p class="MsoNormal" style="text-autospace:none"><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">2005-05-03 </span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">14:12:43</span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New""> LOG:  checkpoint record is at
0/14282C0</span></font><pclass="MsoNormal" style="text-autospace:none"><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">2005-05-03 </span></font><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">14:12:43</span></font><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew""> LOG:  redo record is at 0/14282C0; undo record is at 0/0; shutdown
TRUE</span></font><pclass="MsoNormal" style="text-autospace:none"><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">2005-05-03 </span></font><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">14:12:43</span></font><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew""> LOG:  next transaction ID: 4226; next OID: 22625</span></font><p
class="MsoNormal"style="text-autospace:none"><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">2005-05-03 </span></font><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew"">14:12:43</span></font><font face="Courier New" size="2"><span
style="font-size:10.0pt;font-family:"CourierNew""> LOG:  database system is ready</span></font><p class="MsoNormal"
style="text-autospace:none"><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier
New"">2005-05-03</span></font><font face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier
New"">14:12:58</span></font><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"">
FATAL: unsupported frontend protocol 65535.65535: server supports 1.0 to 3.0</span></font><p class="MsoNormal"
style="text-autospace:none"><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier
New"">2005-05-03</span></font><font face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier
New"">14:13:14</span></font><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"">
LOG: received fast shutdown request</span></font><p class="MsoNormal" style="text-autospace:none"><font face="Courier
New"size="2"><span style="font-size:10.0pt;font-family:"Courier New"">2005-05-03 </span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">14:13:14</span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New""> LOG:  shutting down</span></font><p class="MsoNormal"
style="text-autospace:none"><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier
New"">2005-05-03</span></font><font face="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier
New"">14:13:14</span></font><fontface="Courier New" size="2"><span style="font-size:10.0pt;font-family:"Courier New"">
LOG: database system is shut down</span></font><p class="MsoNormal" style="text-autospace:none"><font face="Courier
New"size="2"><span style="font-size:10.0pt;font-family:"Courier New"">2005-05-03 </span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New"">14:13:14</span></font><font face="Courier New"
size="2"><spanstyle="font-size:10.0pt;font-family:"Courier New""> LOG:  logger shutting down</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">I believe the unsupported frontend protocol message is coming from the ArcCatalog test connection
attempt.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">If this is not the correct forum for this question please direct me to the correct one.  Since this
aninterface issue I thought I would ask here first.</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">I have used Google to search for set up guides but could not find any.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">My current task is to get ArcGis tools to display data from a PostgreSql database (first vector then
image”.</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Any suggestions would be greatly appreciated.</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt; 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">Bruce</span></font></div>

pgsql-interfaces by date:

Previous
From: Fabio Guidi
Date:
Subject: Re: bcc32 libpq compile problem
Next
From: "Zlatko Matic"
Date:
Subject: calculated identity field in views, again...