Madison Kelly <linux@xxxxxxxxxxx> 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
