Thread: shp2pgsql is missing
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! Sue -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Susan E Hurst Principal Consultant Brookhurst Data LLC Email: susan.hurst@brookhurstdata.com Mobile: 314-486-3261
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 On 2020-07-26 14:58, Christoph Moench-Tegeder wrote: > ## 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