| From: | Iñigo Barandiaran <ibarandiaran(at)vicomtech(dot)org> |
|---|---|
| To: | rod(at)iol(dot)ie |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: createdb.exe and psql.exe without Promting Password |
| Date: | 2009-02-10 18:22:24 |
| Message-ID: | 4991C5E0.2080507@vicomtech.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks Raymon.<br>
<br>
I'm using Windows XP.<br>
<br>
What does "visible to the script" means?<br>
<br>
Thanks in advance!<br>
<br>
Best,<br>
<blockquote cite="mid:4991C35C(dot)1010907(at)iol(dot)ie" type="cite">
<pre wrap="">On 10/02/2009 18:04, Inigo Barandiaran wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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?
</pre>
</blockquote>
<pre wrap=""><!---->
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:
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.3/static/libpq-pgpass.html">http://www.postgresql.org/docs/8.3/static/libpq-pgpass.html</a>
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
<a class="moz-txt-link-abbreviated" href="mailto:rod(at)iol(dot)ie">rod(at)iol(dot)ie</a>
Galway Cathedral Recitals: <a class="moz-txt-link-freetext" href="http://www.galwaycathedral.org/recitals">http://www.galwaycathedral.org/recitals</a>
------------------------------------------------------------------
</pre>
</blockquote>
<br>
</body>
</html>
| Attachment | Content-Type | Size |
|---|---|---|
| unknown_filename | text/html | 1.8 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alban Hertroys | 2009-02-10 18:22:29 | Re: Slow database creation |
| Previous Message | Raymond O'Donnell | 2009-02-10 18:11:40 | Re: createdb.exe and psql.exe without Promting Password |