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

Andy Colson andy at squeakycode.net
Fri Aug 26 14:23:18 PDT 2016


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
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>



More information about the postgis-users mailing list