For posterity, I'll mention that running "sudo apt install postgis" like I recommended only works in a pretty sloppy way... It will install the latest postgres (11, as of this writing) on your server in addition to your existing installation. This new installation will be set to run (and perhaps fail) on port 5433. This doesn't really break or affect your existing postgres installation which will continue to run on 5432, but I can't imagine that it's actually the best way to install a simple command line utility like shp2psql.
Any other recommendations are welcome. Adam On Mon, Jul 15, 2019 at 4:02 PM Martha S <[email protected]> wrote: > Thanks, Adam, > > I'd seen that in my research but wanted to be sure first that I wouldn't > mess up my system. > > Martha > > On Monday, July 15, 2019 at 1:47:42 PM UTC-7, Adam Cox wrote: >> >> Hi Martha, >> >> On a similar system (Ubuntu 16.04 and an older version of Arches where I >> had installed postgres using the ubuntu_setup.sh script) when I ran >> shp2psql I found it also missing. The message said I should install it with >> >> sudo apt-get install postgis >> >> After I ran that command (even though this is a fully functional Arches >> installation with postgis already installed, though I guess through >> different means) shp2psql is now available to me. I haven't tested anything >> further, but that may be the best way. >> >> Adam >> >> On Mon, Jul 15, 2019 at 2:25 PM Martha S <[email protected]> wrote: >> >>> Hello, >>> >>> We are running Arches 4.4.2 on Ubuntu 18.04. I'm ready to create some >>> overlays from shapefiles and find SHP2PGSQL to be a recommended part of the >>> conversion. Unfortunately, it is not on my system and I'd like to know the >>> preferred means of adding it. apt-get install --dry-run shp2pgsql did not >>> return anything. >>> >>> For reference, here are the results of postgis_full_version and the >>> contents of my /usr/lib/postgresql/9.6/bin directory >>> >>> postgis_full_version >>> >>> >>> --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- >>> POSTGIS="2.4.4 r16526" PGSQL="96" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" >>> PROJ="Rel. 4.9.3, 15 August 2016" GDAL="GDAL 2.2.3, released 2017/11/20" >>> LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.2.1" RASTER >>> >>> user:/usr/lib/postgresql/9.6/bin$ dir >>> clusterdb initdb pg_dumpall pg_standby postmaster >>> createdb oid2name pg_isready pg_test_fsync psql >>> createlang pg_archivecleanup pg_receivexlog pg_test_timing reindexdb >>> createuser pg_basebackup pg_recvlogical pg_upgrade vacuumdb >>> dropdb pg_controldata pg_resetxlog pg_xlogdump vacuumlo >>> droplang pg_ctl pg_restore pgbench >>> dropuser pg_dump pg_rewind postgres >>> >>> whereis returned nothing, either. >>> >>> Thanks, >>> Martha >>> >>> -- >>> -- To post, send email to [email protected]. To unsubscribe, >>> send email to [email protected]. For more information, visit >>> https://groups.google.com/d/forum/archesproject?hl=en >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "Arches Project" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/archesproject/1497143c-c24c-48ea-b140-3c1371ae72c3%40googlegroups.com >>> <https://groups.google.com/d/msgid/archesproject/1497143c-c24c-48ea-b140-3c1371ae72c3%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > -- To post, send email to [email protected]. To unsubscribe, > send email to [email protected]. For more > information, visit https://groups.google.com/d/forum/archesproject?hl=en > --- > You received this message because you are subscribed to the Google Groups > "Arches Project" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/archesproject/73c7828b-5cf0-4aee-8b6e-f7c859184c23%40googlegroups.com > <https://groups.google.com/d/msgid/archesproject/73c7828b-5cf0-4aee-8b6e-f7c859184c23%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- -- To post, send email to [email protected]. To unsubscribe, send email to [email protected]. For more information, visit https://groups.google.com/d/forum/archesproject?hl=en --- You received this message because you are subscribed to the Google Groups "Arches Project" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/archesproject/CAGYBTau2x0fNezZv6aU-3xeiy%3Dw3hBu7TxbpYKgR%3DiCipoJH8A%40mail.gmail.com.
