[postgis-users] Using raster2pgsql on a system with no postgresqlinstall

[Paragon Corporation]

Darrel,
 
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.
 
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.
 
Way at the bottom of this tutorial we have listed the files you need to copy
to the folder:
 
http://www.bostongis.com/PrinterFriendly.aspx?content_name=postgis_tut01
 
So add to that list libgdal-1.dll, raster2pgsql.exe
 
Hope that helps,
Regina
http://www.postgis.us
 


  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Darrel
Maddy
Sent: Saturday, January 07, 2012 6:36 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Using raster2pgsql on a system with no
postgresqlinstall



Dear all,

 

I may be asking to do the impossible here but here goes.

 

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.

 

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?

 

Hope that makes sense.

 

Darrel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120107/4fad3fa4/attachment.html>