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
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------