Re: [GENERAL] Confusion about users and roles

2010-03-01 Thread C. Bensend
> Generally speaking you don't want to make per-user entries in > pg_hba.conf; it's just too much of a PITA for maintenance, unless > you really need different auth mechanisms for different users. > I'd suggest using "all" for the hba database and user columns whenever > possible. If you want con

Re: [GENERAL] Confusion about users and roles

2010-02-28 Thread Tom Lane
"C. Bensend" writes: >I'm playing around with putting some of my email system's config > into PostgreSQL, and I ran into some behavior I didn't expect today. > ... >I added the postfix user to pg_hba.conf and reloaded PostgreSQL: Generally speaking you don't want to make per-user entrie

[GENERAL] Confusion about users and roles

2010-02-28 Thread C. Bensend
Hey folks, I'm playing around with putting some of my email system's config into PostgreSQL, and I ran into some behavior I didn't expect today. I'm sure this is just misunderstanding on my part, but reading the documentation hasn't cleared it up for me yet. This is PostgreSQL 8.4.2 on Ope