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. ?

HTH,

Greg Williamson
Senior DBA
DigitalGlobe

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: [EMAIL PROTECTED] 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
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users

Reply via email to