[postgis-users] issue loading shapefiles into postgis via batch

[Mark Volz]

Hello,

I am having issues with a Windows batch load script.  This script should scan for any new shapefiles in the "PostGIS Incoming" folder, load the shapefiles into postGIS, then place the shapefiles in a completed folder.  This script seemed to work in the past, but is now complaining about a password - which I did not change.

What is wrong with this script, and or what can I do to specify a password?

###########################################
#      LOAD SHAPEFILES INTO POSTGIS SCRIPT
###########################################

set PATH=C:\Program Files\PostgreSQL\9.2\bin;%PATH%
cd /d "D:\PostGISIncoming\LyonGIS"
rem load data to postgis
for %%f in (*.shp) do shp2pgsql -d -I -s 103749 -W LATIN1 %%f %%~nf | psql -w -U postgres -d lyongis
rem move data to done folder
for %%a in (*.*) do move "%%a" "D:\PostGISIncoming\LyonGIS\Done"



Thanks
Sincerely,
Mark Volz, GISP

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