From: | "Ralph Dell" <RDell(at)CatawbaCountyNC(dot)gov> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | windows 2008 scheduled task problem |
Date: | 2012-02-06 16:26:11 |
Message-ID: | C8E14DAE4E28C647A5DAB20B4F7CB60904872EDA@COCATEX01.cocat.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am running postgresql 8.4.3/ postgis 1.5 on a windows server 2008 R2
I am unable to get the shp2pgsql command to run as scheduled tasks.
There is no problem running any of the commands from the command line or
a python script.
Some sample commands are
shp2pgsql -s 900913 -I -d myshape.shp gis.myshape -u xxx -p yyy >
myshape.txt
or
%POSTGIS_PATH%\shp2pgsql -s 900913 -I -d myshape.shp gis.myshape -u xxx
-p yyy > myshape.txt
or
shp2pgsql -s 900913 -I -d myshape.shp gis.myshape -u xxx -p yyy | psql
-d mydb -U xxx -q
I do not get any output from the scheduled task.
The history tab in the task scheduler will show Task triggered/ task
started / task completed, and report the task successfully completed.
I am running the tasks under a system administrator account.
Any suggestions from someone who has a similar environment.
This is my first post to the list and I hope it is an appropriate place
for the question I and I have provided enough detail.
Ralph Dell
From | Date | Subject | |
---|---|---|---|
Next Message | Andrus | 2012-02-06 16:29:00 | Re: How to create crosstab with 3 values in every crosstab column |
Previous Message | Misa Simic | 2012-02-06 16:01:53 | Re: How to create crosstab with 3 values in every crosstab column |