"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