Mauro,
Is there a reason you want to use PostgreSQL 9.4 and not something newer? PostgreSQL 9.4 is pretty old at this point. If you can I would suggest using a newer version. Note that BigSQL PostgreSQL 9.4 has its own PostGIS too. I'm not sure which versions are offered for 9.4. It does lack SFCGAL in it. If you do from command shell (cd'd into bigsql folder) pgc list it will give a list of extension options. Then it should be as simple as pgc install postgis23 But if you want to use 9.4 and the 2.3.8dev binaries, then YES, you'd need to use this one https:// <http://www.enterprisedb.com/downloads/postgres-postgresql-downloads> www.enterprisedb.com/downloads/postgres-postgresql-downloads From: postgis-users [mailto:[email protected]] On Behalf Of Mauro Gregorio Binetti Sent: Tuesday, May 29, 2018 12:19 PM To: PostGIS Users Discussion <[email protected]> Cc: Mauro Gregorio Binetti <[email protected]> Subject: Re: [postgis-users] Installing PostGIS 2.3.8 over PostGres 9.4, Windows Hi Regina, first of all thank you very much for responding so fast. Your assumption is correct. I installed PostgreSQL 9.4.18 using BigSQL distribution. Your explanation is very clear to me now. I need to use version 9.4 of PostgreSQL so, I understand I have to start by changing this one. My reference must be https:// <http://www.enterprisedb.com/downloads/postgres-postgresql-downloads> www.enterprisedb.com/downloads/postgres-postgresql-downloads Correct? Then I can repeat PostGIS installation using the same zip file: https://winnie.postgis.net/download/windows/pg94/buildbot/postgis-pg94-binaries-2.3.8devw64gcc48.zip Correct? Regards, Mauro On Tue, May 29, 2018 at 5:02 PM, Regina Obe <[email protected] <mailto:[email protected]> > wrote: Which distribution of PostgreSQL are you using? It looks to me like you are using a distribution incompatible with the EDB distribution which the 9.4 binaries I built were built for. For example if you are using BigSQL, only PostgreSQL 9.5 and above binaries on Winnie will work with that. The reason for this is Prior to PostgreSQL 9.5, EnterpriseDb used to compile their windows versions with FLOAT8PASSBYVAL = false So to accommodate that, I built < 9.5 with FLOAT8PASSBYVAL = false However BigSQL windows distributions have always been built with FLOAT8PASSBYVAL = true So the 9.4 builds I built for EDB WILL NOT WORK with 9.4 BigSQL In Version PostgreSQL 9.5+, EDB changed their windows builds to build with FLOAT8PASSBYVAL =true as well So from that point forward, the builds are compatible. <http://postgis.net/windows_downloads/> http://postgis.net/windows_downloads/ (that's why I put a note on that page that for BigSQL 9.5+, you can use the binaries here if you want extra stuff. I probably maybe should have explained that better (and put a big DO NOT USE if using < 9.5 on BigSQL) Thanks, Regina From: postgis-users [mailto: <mailto:[email protected]> [email protected]] On Behalf Of Mauro Gregorio Binetti Sent: Tuesday, May 29, 2018 10:29 AM To: <mailto:[email protected]> [email protected] Cc: Mauro Gregorio Binetti < <mailto:[email protected]> [email protected]> Subject: [postgis-users] Installing PostGIS 2.3.8 over PostGres 9.4, Windows Hi guys, I have downloaded the subsequent zipfile: <https://winnie.postgis.net/download/windows/pg94/buildbot/> https://winnie.postgis.net/download/windows/pg94/buildbot/ postgis-pg94-binaries-2.3.8devw64gcc48.zip FOr the subsequent command: "%PGBIN%\psql" -d "%THEDB%" -c "CREATE EXTENSION postgis;" shown in bat file: makepostgisdb_using_extensions.bat I have the subsequent error: ERROR: incompatible library "C:/__APPL/pg94/../pg94/lib/postgresql/postgis-2.3.dll": magic block mismatch DETTAGLI: Server has FLOAT8PASSBYVAL = true, library has false. I have modified boolean flag value to false in subsequent files: * pg94\include\postgresql\server\pg_config.h * pg94\include\pg_config.h but I continue to have same error. Can you please give me some advice. Thank you in advance. Mauro _______________________________________________ postgis-users mailing list [email protected] <mailto:[email protected]> https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
