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

[Bo Victor Thomsen]

There are several ways to do this. One of the easiest (and most 
insecure) is to set the PGPASSWORD environment variable with the 
password for "postgres" user in the script before the psql command.


Regards

Bo Victor Thomsen

AestasGIS

Denmark


Den 26/08/16 kl. 15:59 skrev 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***
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users

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