[postgis-users] Cron / shp2psql

Gregory Williamson Gregory.Williamson at digitalglobe.com
Sun Jun 1 15:53:48 PDT 2008

In the cron job you may not have the environment (in particular PATH) set; try adding an explicit paths to all file and executable references. ?


Greg Williamson
Senior DBA

Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information and must be protected in accordance with those provisions. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.

(My corporate masters made me say this.)

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net on behalf of Dan Blomberg
Sent: Sun 6/1/2008 3:20 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Cron / shp2psql
On this note, I thought I had fixed my problem but it doesn't work 
either.  I can even run it as a bat but I can't call the bat in visual 
basic or just run the command that is in the bat file.

chris brisendine wrote:
> I have cron running a shell script "
> shp2pgsql -d -s 4326 /home/storm/ww/TOR.shp torpoly wxsvr>torpoly.sql
> sleep 7
> shp2pgsql -d -s 4326 /home/storm/ww/SVR.shp svrpoly wxsvr| psql -d  wxsvr
> echo `date`>updated.txt
> "
> When i run this from the command line it works flawless but when cron
> runs it it dosent update my nwswarnings! Any idea's?
> I know the new warnings are being downloaded and the the script is
> running cause it writes to the updated.txt file when it runs.
> I have tryed it two different ways but no luck...
postgis-users mailing list
postgis-users at postgis.refractions.net

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

More information about the postgis-users mailing list