Thread: BUG #5957: createdb with description and md5 auth forces to provide password twice

The following bug has been logged online:

Bug reference:      5957
Logged by:          Grzegorz Szpetkowski
Email address:      gszpetkowski@gmail.com
PostgreSQL version: 9.0.3
Operating system:   Ubuntu 10.10
Description:        createdb with description and md5 auth forces to provide
password twice
Details:

How to reproduce the problem:

1.Create new role with (encrypted password):
createuser -SdRP user
2.In PostgreSQL 9.0.3 I found pg_hba.conf with local all all ident, so
change to local all all md5
3.Restart/Reload used cluster
4.Execute createdb -U user mydb "My DB Description"

Output:

Password:
Password:

creatdb command prompts password twice and I think it's improper behaviour
(and documentation is silent about that).

Grzegorz Szpetkowski wrote:
>
> The following bug has been logged online:
>
> Bug reference:      5957
> Logged by:          Grzegorz Szpetkowski
> Email address:      gszpetkowski@gmail.com
> PostgreSQL version: 9.0.3
> Operating system:   Ubuntu 10.10
> Description:        createdb with description and md5 auth forces to provide
> password twice
> Details:
>
> How to reproduce the problem:
>
> 1.Create new role with (encrypted password):
> createuser -SdRP user
> 2.In PostgreSQL 9.0.3 I found pg_hba.conf with local all all ident, so
> change to local all all md5
> 3.Restart/Reload used cluster
> 4.Execute createdb -U user mydb "My DB Description"
>
> Output:
>
> Password:
> Password:
>
> creatdb command prompts password twice and I think it's improper behaviour
> (and documentation is silent about that).

FYI, this will be fixed in Postgres 9.1.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +