<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<span style="color:rgb(32, 31, 30);font-size:14.6667px;background-color:rgb(255, 255, 255);display:inline !important"></span>
<div><span style="color:rgb(32, 31, 30);font-size:14.6667px;background-color:rgb(255, 255, 255);display:inline !important">Hi Folks,</span></div>
<div><span style="color:rgb(32, 31, 30);font-size:14.6667px;background-color:rgb(255, 255, 255);display:inline !important"><br>
</span></div>
<div><span style="color:rgb(32, 31, 30);font-size:14.6667px;background-color:rgb(255, 255, 255);display:inline !important">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 !important"><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 !important">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 !important"><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 !important"><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 !important">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 !important">C:/Program
Files/PostgreSQL/13/lib/. <span style="color:rgb(32, 31, 30);font-family:"Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif;font-size:14.6667px;text-align:start;background-color:rgb(255, 255, 255);display:inline !important">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 !important"><span style="color:rgb(32, 31, 30);font-family:"Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif;font-size:14.6667px;text-align:start;background-color:rgb(255, 255, 255);display:inline !important"><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 !important"><span style="color:rgb(32, 31, 30);font-family:"Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif;font-size:14.6667px;text-align:start;background-color:rgb(255, 255, 255);display:inline !important"><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 !important"><span style="color:rgb(32, 31, 30);font-family:"Segoe UI", "Segoe UI Web (West European)", "Segoe UI", -apple-system, BlinkMacSystemFont, Roboto, "Helvetica Neue", sans-serif;font-size:14.6667px;text-align:start;background-color:rgb(255, 255, 255);display:inline !important"><span>-david</span></span></span></span></font></div>
</body>
</html>