[postgis-users] loading sql files using batch commands - psql
mwtoews at gmail.com
Tue Nov 20 12:34:03 PST 2012
Look into the .pgpass file, which is used to store a user's
password in plain text in the user's home directory. Several
PostgreSQL applications use the password file, including psql, pgAdmin
III. One notable exception that doesn't yet use the password file is
After you have this file configured for the user/database, the
password will not be required or prompted for your psql command below.
On 21 November 2012 08:01, Mark Volz <MarkVolz at co.lyon.mn.us> wrote:
> I am trying to create a batch program that will update postgis from a directory of shapefiles. I came across http://suite.opengeo.org/opengeo-docs/dataadmin/pgGettingStarted/shp2pgsql.html, which uses psql to load data into postgis. The psql command appears to prompt for a password, which would be fine if I was manually running the batch file. However, I want to set up a scheduled task in windows so that my data gets updated on automatic intervals.
> Is there a way to store a password in a batch file such as " for %%f in (*.sql) do psql -p 5432 -w -U postgres --password mypassword --dbname postgis20 -f %%f?
> If not is there a way to trick a windows batch file to send the password to psql?
> Thanks for any help
> Mark Volz
> GIS Specialist
More information about the postgis-users