Re: Problem V8.1.4 - providing pwd for commandline tools doesn't work anymore - Mailing list pgsql-general

From Magnus Hagander
Subject Re: Problem V8.1.4 - providing pwd for commandline tools doesn't work anymore
Date
Msg-id 6BCB9D8A16AC4241919521715F4D8BCEA35460@algol.sollentuna.se
Whole thread Raw
Responses Re: Problem V8.1.4 - providing pwd for commandline tools doesn't
List 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

pgsql-general by date:

Previous
From: Markus Schiltknecht
Date:
Subject: Re: Best high availability solution ?
Next
From: Arnaud Lesauvage
Date:
Subject: Re: Best high availability solution ?