On 10/02/2009 18:04, Inigo Barandiaran wrote: > I would like to create an script that includes calls to createdb.exe and > psql.exe. I would like to use them with a user but without asking or > prompting for pasword. For example: > createdb.exe -T template0 -U MyPosgresUser MyDataBaseName. > > I've read that if I define an environment variable like SET > PGPPASSWORD=MyPosgresUserPassword, both calls dont ask for password. I've > tested this variable in different platforms and does not work. > Do you know how so solve it?
What platform(s) did you test it on? Are you sure that the environment variable was visible to the script? Another option is to use a .pgpass file: http://www.postgresql.org/docs/8.3/static/libpq-pgpass.html Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland r...@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
