[pgrouting-users] "procedure could not be found" when enabling pgRouting

pgRouting pgrouting-users
1

Hi Folks,

I would like to add pgRouting to an existing installation (PostgreSQL = 13.0 64-bit (build 1914) and PostGIS = 3.0). I backup up my database using pgdump and downloaded Winnie pgRouting Experimental Build 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 “CREATE EXTENSION pgrouting;” in a pgadmin4 query window. I received this error:

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

I see the file libpgrouting-3.1.dll in C:/Program Files/PostgreSQL/13/lib/. What procedure cannot be found? How can I enable pgRouting?

Thank you,
-david

2

Hi David,

By the looks of it, your pgRouting binary seems to be for Postgres 9.6. This location (https://winnie.postgis.net/download/windows/pg13/buildbot/) seems to have the experimental pgRouting and PostGIS build for PG13.

Thanks

···

https://about.me/chintanpathak

3

Ah, that makes sense. I didn’t see that there were multiple builds. Thank you Chintan.

···

From: Pgrouting-users pgrouting-users-bounces@lists.osgeo.org on behalf of Chintan Pathak cp84@uw.edu
Sent: Tuesday, December 29, 2020 9:08 AM
To: pgRouting users mailing list pgrouting-users@lists.osgeo.org
Subject: Re: [pgrouting-users] “procedure could not be found” when enabling pgRouting

Hi David,

By the looks of it, your pgRouting binary seems to be for Postgres 9.6. This location (https://winnie.postgis.net/download/windows/pg13/buildbot/) seems to have the experimental pgRouting and PostGIS build for PG13.

Thanks

https://about.me/chintanpathak

On Mon, Dec 28, 2020 at 3:30 AM David Lawrence Epstein <davideps@tauex.tau.ac.il> wrote:

Hi Folks,

I would like to add pgRouting to an existing installation (PostgreSQL = 13.0 64-bit (build 1914) and PostGIS = 3.0). I backup up my database using pgdump and downloaded Winnie pgRouting Experimental Build 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 “CREATE EXTENSION pgrouting;” in a pgadmin4 query window. I received this error:

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

I see the file libpgrouting-3.1.dll in C:/Program Files/PostgreSQL/13/lib/. What procedure cannot be found? How can I enable pgRouting?

Thank you,
-david

Pgrouting-users mailing list
Pgrouting-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/pgrouting-users