<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7652.24">
<TITLE>RE: [postgis-users] Cron / shp2psql</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/plain format -->
<P><FONT SIZE=2>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. ?<BR>
<BR>
HTH,<BR>
<BR>
Greg Williamson<BR>
Senior DBA<BR>
DigitalGlobe<BR>
<BR>
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.<BR>
<BR>
(My corporate masters made me say this.)<BR>
<BR>
<BR>
<BR>
-----Original Message-----<BR>
From: postgis-users-bounces@postgis.refractions.net on behalf of Dan Blomberg<BR>
Sent: Sun 6/1/2008 3:20 PM<BR>
To: PostGIS Users Discussion<BR>
Subject: Re: [postgis-users] Cron / shp2psql<BR>
<BR>
On this note, I thought I had fixed my problem but it doesn't work<BR>
either. I can even run it as a bat but I can't call the bat in visual<BR>
basic or just run the command that is in the bat file.<BR>
<BR>
chris brisendine wrote:<BR>
> I have cron running a shell script "<BR>
> shp2pgsql -d -s 4326 /home/storm/ww/TOR.shp torpoly wxsvr>torpoly.sql<BR>
> sleep 7<BR>
> shp2pgsql -d -s 4326 /home/storm/ww/SVR.shp svrpoly wxsvr| psql -d wxsvr<BR>
> echo `date`>updated.txt<BR>
> "<BR>
> When i run this from the command line it works flawless but when cron<BR>
> runs it it dosent update my nwswarnings! Any idea's?<BR>
> I know the new warnings are being downloaded and the the script is<BR>
> running cause it writes to the updated.txt file when it runs.<BR>
> I have tryed it two different ways but no luck...<BR>
> <BR>
_______________________________________________<BR>
postgis-users mailing list<BR>
postgis-users@postgis.refractions.net<BR>
<A HREF="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>
<BR>
</FONT>
</P>
</BODY>
</HTML>