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

[Mauro Gregorio Binetti]

Yes Regina, it's a must due to the actual customer installation.
Thank you very much for your suggestions. I solved every problem!

Regards,
Mauro

On Tue, May 29, 2018 at 6:52 PM, Regina Obe <lr at pcorp.us> wrote:

> 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://www.enterprisedb.com/downloads/postgres-postgresql-downloads
>
>
>
>
>
>
>
>
>
>
>
> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] *On
> Behalf Of *Mauro Gregorio Binetti
> *Sent:* Tuesday, May 29, 2018 12:19 PM
> *To:* PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> *Cc:* Mauro Gregorio Binetti <maurogregorio.binetti at exprivia.it>
> *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://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/po
> stgis-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
>
>
>
> _______________________________________________
> 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/20180530/382cfbeb/attachment.html>