From: | Jason Stone <pgsql-admin(at)dfmm(dot)org> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | password authentication with external passwd file |
Date: | 2005-08-27 08:31:25 |
Message-ID: | 20050827001001.L70885@treehorn.dfmm.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello all.
I am currently running postgresql-7.2, and I have my pg_hba.conf
configured to use password authentication with external passwd files.
eg:
pg_hba.conf:
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
db1.pwd:
postgres:bwoMq9dRTqHlI
user1:WaC3rSwu.1V2A
db1.pwd:
postgres:MT0RIEZ2rN.IY
user1:1U6pT5d0T/fcY
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
different databases?
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.
-Jason
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (FreeBSD)
Comment: See https://private.idealab.com/public/jason/jason.gpg
iD8DBQFDECTdswXMWWtptckRAhcgAKCC6X3r+tTyhR4beK8JHqEc1KUAzACffPxG
CZWF0SSSWyRFV71D4DcOeTY=
=SMsw
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-08-27 13:30:49 | Re: password authentication with external passwd file |
Previous Message | Bruno Wolff III | 2005-08-27 06:21:50 | Re: Hash index |