Re: BUG #13741: vacuumdb does not accept valid password

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: Haribabu Kommi <kommi(dot)haribabu(at)gmail(dot)com>
Cc: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, brown(at)fastmail(dot)com, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #13741: vacuumdb does not accept valid password
Date: 2015-11-04 07:26:58
Message-ID: CAB7nPqQwzNfZ5nWK8Cu=0sOqfPFXcX7oGHW44o7yN+UQo8x1rQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

On Wed, Nov 4, 2015 at 9:24 AM, Haribabu Kommi wrote:
> On Wed, Nov 4, 2015 at 12:06 AM, Michael Paquier wrote:
> Why I used a double pointer is to support the scenario like the following.
> - There is no password requirement for Postgres, template1 and
> maintenance db that is provided by the user.
> - But there is a password requirement for user databases.
> - If user doesn't provide the password during connection to
> Maintenance database, later it prompts for
> password while connecting to user database.
> - Without the double pointer, further on for every database, it
> prompts for the password and also
> the case of --analyze-in-stages prompts for password for the all the stages.

Yeah, I thought a bit about that while writing the last patch but
that's quite narrow, no? So I didn't think it was worth doing, the
approach to request a password only after connecting to the
maintenance database instead of relying on the first one given out by
user looked more simple and solid to me, and is able to cover all the
test scenarios either way as one can specify the maintenance database
he wishes to connect to.
Thoughts from other folks?
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2015-11-04 07:30:01 Re: BUG #13741: vacuumdb does not accept valid password
Previous Message Michael Paquier 2015-11-04 07:09:41 Re: Re: BUG #13685: Archiving while idle every archive_timeout with wal_level hot_standby

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2015-11-04 07:30:01 Re: BUG #13741: vacuumdb does not accept valid password
Previous Message Etsuro Fujita 2015-11-04 07:26:37 Re: ATT_FOREIGN_TABLE and ATWrongRelkindError()