Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

Next:From: Michael FuhrDate: 2005-08-27 13:30:49
Subject: Re: password authentication with external passwd file
Previous:From: Bruno Wolff IIIDate: 2005-08-27 06:21:50
Subject: Re: Hash index

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group