createdb.exe and psql.exe without Promting Password

From: Inigo Barandiaran <ibarandiaran(at)vicomtech(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: createdb.exe and psql.exe without Promting Password
Date: 2009-02-10 18:04:51
Message-ID: 21939250.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi.

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?

Thanks in advance!!
--
View this message in context: http://www.nabble.com/createdb.exe-and-psql.exe-without-Promting-Password-tp21939250p21939250.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2009-02-10 18:10:51 Re: createdb.exe and psql.exe without Promting Password
Previous Message Richard Huxton 2009-02-10 17:45:27 Re: does anyone know what to use in pg_hba.conf that will allow me to run cronjobs with pg_dump?