<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 9.00.8112.16440">
<STYLE>@font-face {
font-family: Calibri;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 72.0pt 72.0pt 72.0pt 72.0pt; }
P.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt; mso-fareast-language: EN-US
}
LI.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt; mso-fareast-language: EN-US
}
DIV.MsoNormal {
MARGIN: 0cm 0cm 0pt; FONT-FAMILY: "Calibri","sans-serif"; FONT-SIZE: 11pt; mso-fareast-language: EN-US
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.EmailStyle17 {
FONT-FAMILY: "Calibri","sans-serif"; COLOR: windowtext; mso-style-type: personal-compose
}
.MsoChpDefault {
FONT-FAMILY: "Calibri","sans-serif"; mso-fareast-language: EN-US; mso-style-type: export-only
}
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 vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial>Darrel,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial>Way at the bottom of this tutorial we have listed the files
you need to copy to the folder:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01">http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial>So add to that list libgdal-1.dll,
raster2pgsql.exe</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=485452001-08012012><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Darrel Maddy<BR><B>Sent:</B> Saturday, January 07, 2012 6:36
PM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] Using raster2pgsql on a system with no
postgresqlinstall<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=WordSection1>
<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></DIV></BLOCKQUOTE></BODY></HTML>