I've installed PostgreSQL with Postgis (tried both version 9.4 and 9.5 ) on a remote desktop running Windows 7 64bit.
However, when I executed this SQL command: "CREATE EXTENSION postgis" (on PgAdmin run as administrator), this message came up:
ERROR: could not load library "C:/PostgreSQL9_5/lib/rtpostgis-2.2.dll": The specified procedure could not be found.
********** Error **********
ERROR: could not load library "C:/PostgreSQL9_5/lib/rtpostgis-2.2.dll": The specified procedure could not be found. SQL state: XX000
I can confirm that "rtpostgis-2.2.dll" was there.
Please tell me how to fix this. It's so frustrating to uninstall and then reinstall every time but the problem still persisted.
P/s: On my Home PC running Windows 10 64bit, PostgreSQL is running like a charm. Postgis and Pgrouting extension can be created easily.
echo %PATH%
in a cmd prompt on remote machine. If that does not contain a path to the Postgres binaries, then either add it, or runCREATE EXTENSION postgis
from that location.