PG_Sphere

[Gandalf the Gray]

Hi Regina

I could not load PG_Sphere.

I have extracted the archive into my PG folder, and restarted PG.  Upon
create extension, I get "could not load library C:/Program
Files/PostgreSQL/17/lib/pg_sphere.dll:; The specified procedure could not
be found."

Any clue?

On Wed, Oct 9, 2024 at 3:50 PM Gandalf the Gray <pjduplooy.gis at gmail.com>
wrote:

> Thanks Regina.
>
> Appreciate it!
>
> On Wed, Oct 9, 2024 at 3:46 PM Regina Obe <lr at pcorp.us> wrote:
>
>> I’ve put the binaries I built here:
>>
>>
>>
>> https://winnie.postgis.net/download/windows/pg17/buildbot/extras/
>>
>>
>>
>> As far as compiling under mingw, there isn’t anything special I had to do
>> aside from my usual specifying the postgresql version path.
>>
>> So instructions they have assuming you’ve already installed autoconf,
>> gcc++ etc should be sufficient.
>>
>>
>>
>> export OS_BUILD=64
>>
>> export PROJECTS=/projects
>>
>> export GCC_TYPE=
>>
>> export PG_VER=17
>>
>> export
>> PGPATH=${PROJECTS}/postgresql/rel/pg${PG_VER}w${OS_BUILD}${GCC_TYPE}
>>
>> export PATH="${PGPATH}/bin:${PGPATH}/lib:${PATH}"
>>
>>
>>
>> make USE_HEALPIX=0
>>
>> make USE_HEALPIX=0 install
>>
>> make installcheck USE_HEALPIX=0
>>
>>
>>
>> I haven’t tried compiling with HEALPIX since that itself when I tried had
>> additional dependencies to compile which I hadn’t gone thru to investigate.
>>
>>
>>
>> Let me know if you need further help like setting up your tool chain.
>>
>>
>>
>> Thanks,
>>
>> Regina
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> *From:* Gandalf the Gray <pjduplooy.gis at gmail.com>
>> *Sent:* Wednesday, October 9, 2024 9:13 AM
>> *To:* Regina Obe <lr at pcorp.us>; postgis-devel at lists.osgeo.org
>> *Subject:* Re: PG_Sphere
>>
>>
>>
>> Hi Regina.
>>
>>
>>
>> Would it be possible to send me the Mingw build, or to guide me through
>> the build process, as I have MingW setup for Mame.
>>
>>
>>
>> On Tue, Oct 8, 2024 at 5:00 PM Gandalf the Gray <pjduplooy.gis at gmail.com>
>> wrote:
>>
>> Thank you Regina!
>>
>>
>>
>> On Tue, Oct 8, 2024 at 3:59 PM Regina Obe <lr at pcorp.us> wrote:
>>
>> I’m troubleshooting why the PG17 ones I built (and that regressed fine
>> under Mingw) didn’t seem to install under PG17 VC++ build.
>>
>> In all cases before, if I was able to get things to compile under MingW
>> they work fine in VC++ builds.
>>
>>
>>
>> Once I figure that out (whether it’s my fault or something in the
>> pgsphere code), I’ll deploy those binaries.
>>
>> BTW once they tag the 1.5.2 (which has the fix to build under mingw64
>> https://github.com/postgrespro/pgsphere/pull/123 ), I’m planning to
>> include it in the PostGIS windows bundles.
>>
>>
>>
>> Thanks,
>>
>> Regina
>>
>>
>>
>> *From:* Gandalf the Gray <pjduplooy.gis at gmail.com>
>> *Sent:* Tuesday, October 8, 2024 6:42 AM
>> *To:* postgis-devel at lists.osgeo.org
>> *Subject:* PG_Sphere
>>
>>
>>
>> Hi Regina.
>>
>>
>>
>> Thanks a million for PG_Sphere binaries for Windows!!.
>>
>>
>>
>> Any chance of a PG 17 version?
>>
>>
>>
>> Pieter
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20241009/f9d678b3/attachment.htm>