<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";
mso-fareast-language:EN-US;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-GB link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='color:#1F497D'>Dear Regina,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Great. I’ll take a look at the new binaries sometime later in the week. <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Darrel<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>BTW I bought a copy of your excellent book – I will work my way through it over time, but for now Chapter 13 is essential reading!<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB'> postgis-users-bounces@postgis.refractions.net [mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of </b>Paragon Corporation<br><b>Sent:</b> 08 January 2012 20:23<br><b>To:</b> 'PostGIS Users Discussion'<br><b>Subject:</b> Re: [postgis-users] Using raster2pgsql on a system withno postgresqlinstall<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>Darrel,</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>BTW -- We put up newer windows binaries (just yesterday) which I think have some raster2pgsql fixes and also has the officially released geos3-3-2 (not the dev one anymore)</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>I forgot about geos. I've been deliberating whether I should compile libgdal with/wo Geos dependency. I think the last batch I did - it may not be dependent on GEOS.</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>Bborie / Jorge, </span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>does it make a difference anymore if I compile w/wout GEOS? e.g. are their some formats that need geos if I don't or other idiosyncracies. I think it used to.</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>Thanks,</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>Regina</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'><a href="http://www.postgis.us">http://www.postgis.us</a></span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><blockquote style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p> </o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span lang=EN-US style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal style='margin-bottom:12.0pt'><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB'> <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a> <a href="mailto:[mailto:postgis-users-bounces@postgis.refractions.net]">[mailto:postgis-users-bounces@postgis.refractions.net]</a> <b>On Behalf Of </b>Darrel Maddy<br><b>Sent:</b> Sunday, January 08, 2012 3:07 PM<br><b>To:</b> PostGIS Users Discussion<br><b>Subject:</b> Re: [postgis-users] Using raster2pgsql on a system withno postgresqlinstall</span><span lang=EN-US style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Dear Regina,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Many thanks for this – I did not look at the tutorial as it relates to 1.5 and I am using 2 (silly me). However, thankfully you did point me in the right direction, although your enhanced list was a little short. I started to systematically look at which files are needed by raster2pgsql and determined the following list is needed on the client machine (n.b. this also includes the necessary files to connect to a PG db). Here is the directory listing from my ‘working’ (remote system) directory. <o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>02/12/2011 02:07 419,328 psql.exe<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 771,642 raster2pgsql.exe<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 212,992 ssleay32.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>02/12/2011 02:07 180,736 pg_restore.exe<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>02/12/2011 02:07 373,248 pg_dump.exe<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 794,226 shp2pgsql.exe<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 12,288 comerr32.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 634,880 krb5_32.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 83,906 libintl-8.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>02/12/2011 02:07 167,936 libpq.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 1,032,192 libeay32.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 9,622,528 libgdal-1.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 926,208 libiconv-2.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 451,584 libgeos_c-1.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 1,789,952 libgeos-3-3-2dev.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>21/12/2011 10:23 100,352 zlib1.dll<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>My batch file is not working as intended at present but I will resolve that later – the executables seem to all work fine on their own, so I think this is a complete list (but I guess only real use will tell).<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Best wishes and many thanks again for your help.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Darrel<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB'> <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a> <a href="mailto:[mailto:postgis-users-bounces@postgis.refractions.net]">[mailto:postgis-users-bounces@postgis.refractions.net]</a> <b>On Behalf Of </b>Paragon Corporation<br><b>Sent:</b> 08 January 2012 01:25<br><b>To:</b> 'PostGIS Users Discussion'<br><b>Subject:</b> Re: [postgis-users] Using raster2pgsql on a system with no postgresqlinstall<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>Darrel,</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>This should work fine. I haven't tried it, but can't see why it would be any different from shp2pgsql. It should be pretty much the same story as shp2pgsql except you'll need to copy the libgdal-1.dll as well to the folder.</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>I'm not sure if you have tried it before --- but here is a list of files as I recall you need for all the postgis executables to work. I'll update for 1.5.</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>Way at the bottom of this tutorial we have listed the files you need to copy to the folder:</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'><a href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01">http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01</a></span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>So add to that list libgdal-1.dll, raster2pgsql.exe</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>Hope that helps,</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'>Regina</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;mso-fareast-language:EN-GB'><a href="http://www.postgis.us">http://www.postgis.us</a></span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'> <o:p></o:p></span></p><blockquote style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt'><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p> </o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span lang=EN-US style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><hr size=2 width="100%" align=center></span></div><p class=MsoNormal style='margin-bottom:12.0pt'><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif";mso-fareast-language:EN-GB'> <a href="mailto:postgis-users-bounces@postgis.refractions.net">postgis-users-bounces@postgis.refractions.net</a> <a href="mailto:[mailto:postgis-users-bounces@postgis.refractions.net]">[mailto:postgis-users-bounces@postgis.refractions.net]</a> <b>On Behalf Of </b>Darrel Maddy<br><b>Sent:</b> Saturday, January 07, 2012 6:36 PM<br><b>To:</b> <a href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><b>Subject:</b> [postgis-users] Using raster2pgsql on a system with no postgresqlinstall</span><span lang=EN-US style='font-size:12.0pt;font-family:"Times New Roman","serif";mso-fareast-language:EN-GB'><o:p></o:p></span></p><p class=MsoNormal>Dear all,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>I may be asking to do the impossible here but here goes.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We are about to deploy a landscape evolution model across a condor system (comprising ~1000 computers) in order to undertake sensitivity analysis. The output data will comprise hundreds of thousands of GTiff files (each with about 0.5M cells at this stage). My idea was to get the individual ‘clients’ (which run windows) to write output files directly into the db on our linux-based server. Now I just tried a quick check using a batch file that takes *.tif, uses raster2pgsql to create the sql file and issue the psql command to write the files into a database table. This works (of course) on my home windows-based server but each of the clients in the condor system will not have postgres installed. I created a directory on a windows laptop which does not have a PG install and included the executables I thought necessary and an appropriate batch file but, I guess not surprisingly, it did not work. Is there a way to do this without requiring additional software to be installed on the clients? or will I need to just upload files to a server directory and then run the command in batch mode directly on the server? I guess I am just looking to let the condor machines do more of the work.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Alternatively is the source code for raster2psql available for direct integration into the model code? (sorry I am using the windows version to test postgis2). I guess I could also be missing an equally obvious alternative?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Hope that makes sense.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Darrel<o:p></o:p></p></blockquote></blockquote></div></body></html>