The other way is the pgpass file:
https://wiki.postgresql.org/wiki/Pgpass
-Andy
On 8/26/2016 12:27 PM, Bo Victor Thomsen wrote:
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
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/mailman/listinfo/postgis-users
