"Mike Rogers" <temp6453(at)hotmail(dot)com> writes:
> I have tried chaning pg_hba.conf to add the database field to the user,
> but that doesn't seem to help at all.
Make the database field "sameuser", and then the line only allows
connection to one's own database. You will need an escape hatch to
allow you as superuser to get into everyone's db (else you can't run
pg_dumpall). The escape hatch should be a second line in pg_hba.conf
with a tighter authorization method (eg, a secondary password file
with an entry only for you).
regards, tom lane