From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
---|---|
To: | "Alexander Scholz" <alexander(dot)scholz1(at)freenet(dot)de>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Problem V8.1.4 - providing pwd for commandline tools doesn't work anymore |
Date: | 2006-05-31 08:00:18 |
Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCEA35460@algol.sollentuna.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> The latest version (V8.1.4) breaks the setup process of our
> application's installation wizard. We used to call
> "createdb.exe" and piped the password for the postgres user
> (which has been entered by the user in our setup wizard's
> dialogs) into it.
>
> With version V8.1.4 this is not possible anymore, the
> commandline process prompts for the password nevertheless!
> This causes our setup to "hang" (of course it doesn't hang,
> it waits for the invisible commandline process to return,
> which waits for a user input that will never complete as the
> user cannot and shall not see these commandline tools).
>
> Any suggestion? (V8.1.3 and earlier did work fine in this respect.)
Actually, no, v8.1.3 and earlier are the ones that are broken in this
respect, and it was fixed in 8.1.4.
You need to put the password either in a pgpass.conf file
(http://www.postgresql.org/docs/8.1/static/libpq-pgpass.html) or put it
in the PGPASSWORD environment variable
(http://www.postgresql.org/docs/8.1/static/libpq-envars.html - it's
secure on Windows per the comment)
//Magnus
From | Date | Subject | |
---|---|---|---|
Next Message | Arnaud Lesauvage | 2006-05-31 08:07:37 | Re: Best high availability solution ? |
Previous Message | Markus Schiltknecht | 2006-05-31 07:55:05 | Re: Best high availability solution ? |