Cool and I see they had a release 5 days ago. A quick attempt at compile I
wasn’t successful even using the
make USE_HEALPIX=0
I get error:
In file included from src/sparse.c:136:
src/sparse.h:69:5: error: 'INT' redeclared as different kind of symbol
69 | INT = 270, /* INT */
| ^~~
In file included from C:/ming64/mingw64/include/minwindef.h:163,
from C:/ming64/mingw64/include/windef.h:9,
from C:/ming64/mingw64/include/windows.h:69,
from C:/ming64/mingw64/include/winsock2.h:23,
from
C:/ming64/projects/POSTGR~1/rel/pg16w64/include/server/port/win32_port.h:60,
from
C:/ming64/projects/POSTGR~1/rel/pg16w64/include/server/port.h:24,
from
C:/ming64/projects/POSTGR~1/rel/pg16w64/include/server/c.h:1375,
from
C:/ming64/projects/POSTGR~1/rel/pg16w64/include/server/postgres.h:45,
from src/sparse.y:4:
C:/ming64/mingw64/include/winnt.h:299:15: note: previous declaration of 'INT'
with type 'INT' {aka 'int'}
299 | typedef int INT;
| ^~~
src/sparse.h:70:5: error: 'FLOAT' redeclared as different kind of symbol
70 | FLOAT = 271, /* FLOAT */
I didn’t look too deeply to see how to fix the issue, or if it’s just something
about my setup.
Normally these kinds of issues need some conditional handling for mingw64
and/or windows. PostGIS has a couple of special handlings.
If you have any luck let me know. I plan to take a look at it later either way.
Even though it doesn’t rely on PostGIS, I’d be willing to include it as part of
the PostGIS Bundle, or as a separate package under Windows Application Stack
Builder -> Spatial Extensions.
Thanks,
Regina
From: Gandalf the Gray <pjduplooy....@gmail.com>
Sent: Sunday, November 19, 2023 9:53 AM
To: Regina Obe <l...@pcorp.us>
Subject: Re: Windows compile instructions
Hi Regina
There is actually a newer repository:
https://github.com/postgrespro/pgsphere
On Sat, Nov 18, 2023 at 7:05 PM Regina Obe <l...@pcorp.us
<mailto:l...@pcorp.us> > wrote:
Gandalf,
Sorry I keep on meaning to put up my compile instructions and latest PostGIS
build chain up, but everytime I start, I create a mess of things and put it
off, cause I’m midway upgrading my chain to a newer and haven’t swapped out my
mingw setup.
I had written these instructions not too long ago for building pgRouting under
msys/mingw,
https://github.com/pgRouting/pgrouting/wiki/Building-on-windows-with-msys2-and-mingw64-(WIP)
but got stuck when trying to get pgTap Perl dependencies to finish installing
(thus why it still has WIP in the name), so stuck with my old configured chain.
But the idea here, was to have something a bit simpler for people to understand
than my “build everything from scratch” approach.
Just ignore the cmake instructions, and follow the pgSphere instructions for
building.
The key thing here, is using pacman (the mingw64 package manager) to install
the development tool chain.
I have never tried to build pgSphere (except like 15 years ago where I failed
miserably for some reason). But just a warning, at a glance it looks like
pgSphere hasn’t been updated in sometime https://github.com/akorotkov/pgsphere
(and looks like it might only be set to work only thru PG12). So it’s quite
possible it may need some patches to work with newer PostgreSQL versions.
Since it doesn’t appear to have dependencies then you can probably do it with
mingw/msys just fine and using the pacman packaged PostgreSQL.
If the version offered by pacman installer doesn’t suit you, compiling
PostgreSQL from source is fairly trivial as described here
https://www.cybertec-postgresql.com/en/building-postgresql-with-msys2-and-mingw-under-windows/
Regardless whatever you build should be compatible with both mingw64 and
PostgreSQL 64 Windows EDB as long as you include the libgcc_s_seh-1.dll and
libstdc++-6.dll that comes with the mingw64 install and any other dependencies
not shipped with PostgreSQL windows EDB.
I should also note that the pacman packager in that ships with msys2 mingw64,
has pretty much every dependency one would need. Heck it even has postgis,
geos, gdal., but I don’t use those since I tend to name (for example more than
one version of PostgreSQL), and I generally need to test out in development
geos.
Hope that helps,
Regina
From: Gandalf the Gray <pjduplooy....@gmail.com
<mailto:pjduplooy....@gmail.com> >
Sent: Saturday, November 18, 2023 8:10 AM
To: postgis-de...@lists.osgeo.org <mailto:postgis-de...@lists.osgeo.org>
Subject: Windows compile instructions
Hi guys (although I think this is for Regina)
Where is the latest compile instructions for Windows located at.
I have a PG extension that I would like to try and compile for Windows. It is
PG Sphere.
Thanks a whole bunch for any guidance.
Pieter
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/postgis-users
