Re: Getting a DB password to work without editing pg_hba.conf, possible?

Madison Kelly <linux@alteeve.com> writes:
>   I want to find a way to let the user set the password on the new
> database and have postgres actually ask for it without editing the
> default 'pg_hba.conf' file, if at all possible.

There is no such animal as a "database password" in PG.  There are user
passwords.  You can grant or deny a user access to a database altogether,
but you can't predicate it on him supplying a password different from
his (single) login password.

            regards, tom lane