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

[Ben Madin]

Rather than putting a password into a plain text file, we prefer to create
a user with very limit priviliges - ie can only access one schema and can
only create and insert into that schema and read nothing. Then in the
pg_hba.conf give that user local access to your database using trust.

In reality, whether you put in a plain text password or no password, it
should only be for a user with limited priviliges, and no capacity to to
access private data or damage the existing database. If you then limit
their access from the local server, you are getting pretty secure.

Cheers

Ben


On Friday, 26 August 2016, Mark Volz <MarkVolz at co.lyon.mn.us> wrote:

> 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*
>
>
>


-- 
Sent from my iPhone.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160827/494b31fa/attachment.html>