shp2pgsql is missing

On 7/26/20 11:25 AM, Susan Hurst wrote:

How can I acquire or download the shp2pgsql file that I need for the
tiger geocoder?

All of the online searches for a solution have not been helpful.
Supposedly, shp2pgsql is supposed to just be there when postgis is
installed, but it's not.  I even tried updating postgis with:  ALTER
EXTENSION postgis UPDATE;
...but the message just says it's already there:  NOTICE:  version
"3.0.0" of extension "postgis" is already installed.

Where can I find the elusive file so I can install it properly?

Here are the specifics of my system:

Location:   AWS EC2 instance
OS:  FreeBSD 12.1-RELEASE-p7 FreeBSD 12.1-RELEASE-p7 GENERIC  amd64
PG Location:  /usr/local/lib/postgresql/
PG Version:  PostgreSQL 11.7 on amd64-portbld-freebsd12.1, compiled by
FreeBSD clang version 8.0.1 (tags/RELEASE_801/final 366581) (based on
LLVM 8.0.1), 64-bit

locate shp2pgsql   returns nothing

I understood that I should find shp2pgsql in /usr/local/lib/postgresql/,
but its not there.  BTW, it's not in /usr/lib/ either, which is where
most of the online sources say it should be.

I would welcome any insight into finding the missing shp2pgsql file.

Thanks for your help!

How did you install PostGIS?

Sue

--
Adrian Klaver
adrian.klaver@aklaver.com

## Susan Hurst (susan.hurst@brookhurstdata.com):

OS: FreeBSD 12.1-RELEASE-p7 FreeBSD 12.1-RELEASE-p7 GENERIC amd64

There's your answer: the FreeBSD port of PostGIS 3.0
(databases/postgis30) installs shp2pgsql only if option LOADERGUI
has been enabled on the port's build (the port defaults to
LOADERGUI=off). You need to rebuild PostGIS or convince the
maintainer of that port to switch the default (the usual way
for that is the FreeBSD bugzilla system). Perhaps one could even
argue that LOADERGUI should only toggle shp2pgsql-gui, but I
haven't really looked into that.

Regards,
Christoph

--
Spare Space

Thanks, Christoph! Looks like we'll be able to fix this now that we
know what to do.

Sue

---
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Susan E Hurst
Principal Consultant
Brookhurst Data LLC
Email: susan.hurst@brookhurstdata.com
Mobile: 314-486-3261