<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Ah, that makes sense. I didn't see that there were multiple builds. Thank you Chintan.</div>
<div id="appendonsend"></div>
<hr style="display:inline-block;width:98%" tabindex="-1">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>From:</b> Pgrouting-users <pgrouting-users-bounces@lists.osgeo.org> on behalf of Chintan Pathak <cp84@uw.edu><br>
<b>Sent:</b> Tuesday, December 29, 2020 9:08 AM<br>
<b>To:</b> pgRouting users mailing list <pgrouting-users@lists.osgeo.org><br>
<b>Subject:</b> Re: [pgrouting-users] "procedure could not be found" when enabling pgRouting</font>
<div> </div>
</div>
<div>
<div dir="ltr">
<div>Hi David, <br>
</div>
<div><br>
</div>
<div>By the looks of it, your pgRouting binary seems to be for Postgres 9.6. This location (<a href="https://winnie.postgis.net/download/windows/pg13/buildbot/">https://winnie.postgis.net/download/windows/pg13/buildbot/</a>) seems to have the experimental pgRouting
and PostGIS build for PG13. <br>
</div>
<div><br>
</div>
<div>Thanks <br>
</div>
<div><br>
</div>
<div>
<div>
<div dir="ltr" class="x_gmail_signature">
<div dir="ltr"><a href="https://about.me/chintanpathak" target="_blank">https://about.me/chintanpathak</a></div>
</div>
</div>
<br>
</div>
</div>
<br>
<div class="x_gmail_quote">
<div dir="ltr" class="x_gmail_attr">On Mon, Dec 28, 2020 at 3:30 AM David Lawrence Epstein <<a href="mailto:davideps@tauex.tau.ac.il">davideps@tauex.tau.ac.il</a>> wrote:<br>
</div>
<blockquote class="x_gmail_quote" style="margin:0px 0px 0px 0.8ex; border-left:1px solid rgb(204,204,204); padding-left:1ex">
<div dir="ltr"><span style="color:rgb(32,31,30); font-size:14.6667px; background-color:rgb(255,255,255); display:inline"></span>
<div><span style="color:rgb(32,31,30); font-size:14.6667px; background-color:rgb(255,255,255); display:inline">Hi Folks,</span></div>
<div><span style="color:rgb(32,31,30); font-size:14.6667px; background-color:rgb(255,255,255); display:inline"><br>
</span></div>
<div><span style="color:rgb(32,31,30); font-size:14.6667px; background-color:rgb(255,255,255); display:inline">I would like to add pgRouting to an existing installation (PostgreSQL = 13.0 64-bit (build 1914) and PostGIS = 3.0)</span><span style="color:rgb(32,31,30); font-size:14.6667px">.
I backup up my database using pgdump and downloaded </span><span style="color:rgb(32,31,30); font-size:14.6667px">Winnie pgRouting Experimental Build </span><span style="color:rgb(32,31,30); font-size:14.6667px">pgrouting-pg96-binaries-3.0w64gcc81. I copied
the folders to the existing installation and overwrote. After rebooting, PostgreSQL started again and my database works as before. Since I already have PostGIS enabled, I just issued "</span><span style="color:rgb(32,31,30); font-size:14.6667px">CREATE EXTENSION
pgrouting;" in a pgadmin4 query window. I received this error:</span></div>
<div><span style="color:rgb(32,31,30); font-size:14.6667px"><br>
</span></div>
<div><span style="color:rgb(32,31,30); font-size:14.6667px; background-color:rgb(255,255,255); display:inline"><span style="color:rgb(34,34,34); font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace; font-size:12.95px; text-align:left; background-color:rgb(255,255,255); display:inline">ERROR:
could not load library "C:/Program Files/PostgreSQL/13/lib/libpgrouting-3.1.dll": The specified procedure could not be found. SQL state: 58P01</span><br>
</span></div>
<div><span style="color:rgb(32,31,30); font-size:14.6667px; background-color:rgb(255,255,255); display:inline"><span style="color:rgb(34,34,34); font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace; font-size:12.95px; text-align:left; background-color:rgb(255,255,255); display:inline"><br>
</span></span></div>
<div><font color="#201f1e"><span style="font-size:14.6667px">I see the file <span style="color:rgb(34,34,34); font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace; font-size:12.95px; text-align:left; background-color:rgb(255,255,255); display:inline">libpgrouting-3.1.dll </span>in <span style="color:rgb(34,34,34); font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace; font-size:12.95px; text-align:left; background-color:rgb(255,255,255); display:inline">C:/Program
Files/PostgreSQL/13/lib/. <span style="color:rgb(32,31,30); font-size:14.6667px; text-align:start; background-color:rgb(255,255,255); display:inline">What procedure cannot be found? How can I enable pgRouting?<span> </span></span></span></span></font></div>
<div><font color="#201f1e"><span style="font-size:14.6667px"><span style="color:rgb(34,34,34); font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace; font-size:12.95px; text-align:left; background-color:rgb(255,255,255); display:inline"><span style="color:rgb(32,31,30); font-size:14.6667px; text-align:start; background-color:rgb(255,255,255); display:inline"><span><br>
</span></span></span></span></font></div>
<div><font color="#201f1e"><span style="font-size:14.6667px"><span style="color:rgb(34,34,34); font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace; font-size:12.95px; text-align:left; background-color:rgb(255,255,255); display:inline"><span style="color:rgb(32,31,30); font-size:14.6667px; text-align:start; background-color:rgb(255,255,255); display:inline"><span>Thank
you,</span></span></span></span></font></div>
<div><font color="#201f1e"><span style="font-size:14.6667px"><span style="color:rgb(34,34,34); font-family:"Source Code Pro",SFMono-Regular,Menlo,Monaco,Consolas,"Liberation Mono","Courier New",monospace; font-size:12.95px; text-align:left; background-color:rgb(255,255,255); display:inline"><span style="color:rgb(32,31,30); font-size:14.6667px; text-align:start; background-color:rgb(255,255,255); display:inline"><span>-david</span></span></span></span></font></div>
</div>
_______________________________________________<br>
Pgrouting-users mailing list<br>
<a href="mailto:Pgrouting-users@lists.osgeo.org" target="_blank">Pgrouting-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/pgrouting-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/pgrouting-users</a><br>
</blockquote>
</div>
</div>
</body>
</html>