password authentication with external passwd file

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-----

Responses

Browse pgsql-admin by date

  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