Madison Kelly <linux(at)alteeve(dot)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