Re: Selective authentication?

"Charley L. Tiggs" <ctiggs@xpressdocs.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