I am currently running postgresql-7.2, and I have my pg_hba.conf
configured to use password authentication with external passwd files.
local db1 all password db1.pwd
host db1 all 127.0.0.1 255.255.255.255 password db2.pwd
local db2 all password db1.pwd
host db2 all 127.0.0.1 255.255.255.255 password db2.pwd
I would like to upgrade to postgresql-8.0, but as far as I can tell, this
feature is not present in 8.0 - indeed, it looks like 7.2 may be the last
version with that feature.
I would like to know first, if I'm mistaken, or if external passwd files
are now specified in some other way, or must be enabled at compile time or
something like that; ie, am I doing something wrong?
If this feature is indeed no longer supported, is there some other way
that I can allow the same username to have different passwords on
The background is that this is a hosting environment, and each customer is
given one database to use however they want; different human users should
be able to create database users with the same username without
accidentally granting each other rights on their own databases. We
currently do this by maintaining a password file per user/database, and
letting users put whatever usernames and passwords they want into the
password file for their database.