From: Jason Stone <pgsql-admin@dfmm.org>
To: pgsql-admin@postgresql.org
Subject: password authentication with external passwd file
Date: Sat, 27 Aug 2005 01:31:25 -0700 (PDT)
Message-ID: <20050827001001.L70885@treehorn.dfmm.org> (raw)
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: pgsql-admin@dfmm.org
Subject: Re: password authentication with external passwd file
In-Reply-To: <20050827001001.L70885@treehorn.dfmm.org>
References: <20050827001001.L70885@treehorn.dfmm.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox