Re: Selective authentication?

"Charley L. Tiggs" <ctiggs(at)xpressdocs(dot)com> writes:
> For information on setting up a .pgpass file:
> http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html

.pgpass for everyone is one way, but there are others. If this is
all going to be local connections, you could also think about
setting up your pg_hba.conf file along the lines of

local any dbadmin md5
local any any ident

This would have the effect of requiring a password from anyone trying to
log in as dbadmin. For every other database user name, there'd be a
check that they were logged in under the same Unix user name, and if so
they'd be let in without a password.

Ident is not too trustworthy across the network, but for local
connections it should be fine.

regards, tom lane