[postgis-users] Installing PostGIS 2.3.8 over PostGres 9.4, Windows

[Mauro Gregorio Binetti]

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://
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 <lr at pcorp.us> 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/
>
> (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:postgis-users-bounces at lists.osgeo.org] *On
> Behalf Of *Mauro Gregorio Binetti
> *Sent:* Tuesday, May 29, 2018 10:29 AM
> *To:* postgis-users at lists.osgeo.org
> *Cc:* Mauro Gregorio Binetti <maurogregorio.binetti at exprivia.it>
> *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/ 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
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20180529/dc149d13/attachment.html>