How can I solve this problem? I have Win10 64 bit and PostgreSQL 11.
just copy these two .dlls ("libeay32.dll" and "ssleay32.dll") from bin/postgisgui folder and paste them in bin folder.
We're looking for long answers that provide some explanation and context. Don't just give a one-line answer; explain why your answer is right, ideally with citations. Answers that don't include explanations may be removed.
So this worked for me but no promises because I don't really know what I did I just followed some stuff I found else where. Now I'm on win 10 installing PostgreSQL 11.5 and postgis 2.5 (installed through the native application stack builder) all 64bit and I just did a new install of them all.
Then I followed the instructions here and copped the dll files "libeay32.dll" and "ssleay32.dll" from Postgresql>11>bin>postgisgui into the bin folder just above it. Note I did all of this without having opened up pgadmin or anything else yet, idk if that would have an effect on this. Then I opened up pgadmin 4 and went to the db I wanted to enable postgis on and instead of querying "CREATE EXTENSION postgis" (bc that didnt wana work and threw a new error) I used the gui tree on the left and went to extension>create extension and created an extension to postgis. At that point everything seemed to be working as normal, and I installed the rest of the extensions according to the normal querying style (exp "CREATE EXTENSION postgis_topology") and was able to execute all the commands to the right of this page without error. This is the full response to "SELECT postgis_full_version();"
"POSTGIS="2.5.2 r17328" [EXTENSION] PGSQL="110" GEOS="3.7.0-CAPI-1.11.0 3.7.1" SFCGAL="1.3.2" PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.4, released 2018/03/19 GDAL_DATA not found" LIBXML="2.7.8" LIBJSON="0.12" LIBPROTOBUF="1.2.1" TOPOLOGY RASTER"
I did a little bit of messing around and it seems to not be throwing any errors when calling functions but I havnt tested it thoroughly.
protected by Community♦ Aug 17 at 10:55
Thank you for your interest in this question.
Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?