<div dir="auto"><div>Regina, <div dir="auto">I don't see how raster2pgsql depends on libpq. It does depend on liblwgeom, librtcore though. <br><br><div data-smartmail="gmail_signature" dir="auto">Mateusz Loskot, <a href="mailto:mateusz@loskot.net">mateusz@loskot.net</a><br>(Sent from mobile) </div></div><br><br><div class="gmail_quote"><div dir="ltr">On Fri, 16 Nov 2018, 08:19 Michał Garnysz <<a href="mailto:garnysz.michal@gmail.com">garnysz.michal@gmail.com</a> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I noticed many of things you described and im i doubt there is any clean way to get it working. It looked like simple task get tar ball of postgres & postgis and make it work. (was even able to configure and make postgis but was installation dependant)<br>I made it run instance just overloading some param -L while executing initdb - on extracted binaries on clean ubuntu - not 100% all was working fine but where able to add extension and populate data.<br><br>It's sad that you can apt-get all of this in like 5steps, but there is no way to make it work form one binary (not installed) folder - there are ready to use docker container db with spatial but it's another dependency to project (and just for tests it's an overkill) <br>Or maybe someone prove me wrong, anyone - please :)</div><br><div class="gmail_quote"><div dir="ltr">czw., 15 lis 2018 o 20:54 Regina Obe <<a href="mailto:lr@pcorp.us" target="_blank" rel="noreferrer">lr@pcorp.us</a>> napisał(a):<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div class="m_5326344346905988773m_949792229079969626WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> I think we can make it a bit easier on them and also easier on people who just want the commandline tools<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="m_5326344346905988773m_949792229079969626MsoListParagraph"><u></u><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><span>1)<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Right now you can't compile the commandlines without having postgres installed unless you hack the make scripts<u></u><u></u></span></p><p class="m_5326344346905988773m_949792229079969626MsoListParagraph"><u></u><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><span>2)<span style="font:7.0pt "Times New Roman""> </span></span></span><u></u><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">It has come to my attention that raster2pgsql has a dependency on libpq. I'm not sure why it should when I thought it just emits SQL similar to shp2pgsql (which has no libpq dependency).<u></u><u></u></span></p><p class="m_5326344346905988773m_949792229079969626MsoListParagraph"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">So this sounds like a dependency that may be accidental.<u></u><u></u></span></p><p class="m_5326344346905988773m_949792229079969626MsoListParagraph"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="m_5326344346905988773m_949792229079969626MsoListParagraph"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="m_5326344346905988773m_949792229079969626MsoListParagraph"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="m_5326344346905988773m_949792229079969626MsoListParagraph"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><div style="border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt"><div><div style="border:none;border-top:solid #e1e1e1 1.0pt;padding:3.0pt 0in 0in 0in"><p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Paul Ramsey<br><b>Sent:</b> Thursday, November 15, 2018 2:39 PM<br><b>To:</b> PostGIS Users Discussion <<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users@lists.osgeo.org</a>><br><b>Subject:</b> Re: [postgis-users] raster2pgsql binary in apt distros<u></u><u></u></span></p></div></div><p class="MsoNormal"><u></u> <u></u></p><div><div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><p class="MsoNormal">Something to think about for our 3.0 release.<u></u><u></u></p></blockquote><div><p class="MsoNormal"><u></u> <u></u></p></div><div><p class="MsoNormal">Might need to be ticketed and assigned to packagers? It's not a big ask, but it's easy to forget if they just copy'n'ship the old specs.<u></u><u></u></p></div><div><p class="MsoNormal"><br>P<u></u><u></u></p></div><div><p class="MsoNormal"> <u></u><u></u></p></div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><p class="MsoNormal"><br><br><br>> -----Original Message-----<br>> From: postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users-bounces@lists.osgeo.org</a>] On Behalf<br>> Of Nils Nolde<br>> Sent: Thursday, November 15, 2018 5:55 AM<br>> To: <a href="mailto:postgis-users@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users@lists.osgeo.org</a><br>> Subject: [postgis-users] raster2pgsql binary in apt distros<br>> <br>> Hi,<br>> <br>> I had trouble accessing the raster2pgsql binary with different apt postgresql-x-<br>> postgis-x distros in the past. It<span style="font-family:"Tahoma",sans-serif">�</span>s not callable as executable and I can<span style="font-family:"Tahoma",sans-serif">�</span>t find it<br>> in the usual bin/ directories. I can only access it when installing <span style="font-family:"Tahoma",sans-serif">�</span>apt-get<br>> install postgis<span style="font-family:"Tahoma",sans-serif">�</span> which leaves me with a postgresql v10 distro. Not a<br>> dealbreaker, but a bit annoying. So my questions are:<br>> <br>> - how can I access raster2pgsql in a postgres specific postgis version from apt,<br>> e.g. postgresql-9.6-postgis-2.4?<br>> <br>> - is there a way to compile the tool independent of a postgis installation, as<br>> to not have a full postgres installation for just using raster2pgsql? Context:<br>> sometimes I only need the tool in a docker container to update an external<br>> database.<br>> <br>> Or does it need compilation against specific postgis versions? I guess GDAL is a<br>> dependency, but the produced .sql should be rather independent of postgis<br>> versions right?<br>> <br>> Of course I could write my own sql statements for raster import, but it<span style="font-family:"Tahoma",sans-serif">�</span>s sooo<br>> convenient:)<br>> <br>> Many thanks<br>> Nils<br>> _______________________________________________<br>> postgis-users mailing list<br>> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users@lists.osgeo.org</a><br>> <a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><br><br>_______________________________________________<br>postgis-users mailing list<br><a href="mailto:postgis-users@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users@lists.osgeo.org</a><br><a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/postgis-users</a><u></u><u></u></p></blockquote></div></div></div></div></div>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank" rel="noreferrer">postgis-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div></div></div>