[GENERAL] Requiring a password

2008-03-05 Thread Ralph Smith
I guess I'm missing something. Question part A) I have smithrn in ident.conf, and he can now connect as user airburst to same-named DB. I tested and before he couldn't. But when i: ALTER ROLE airburst WITH UNENCRYPTED PASSWORD 'maxwellsmart' ; ALTER ROLE Even after reloading and

Re: [GENERAL] Requiring a password

2008-03-05 Thread Andrej Ricnik-Bay
On 06/03/2008, Ralph Smith [EMAIL PROTECTED] wrote: I guess I'm missing something. Question part A) Even after reloading and restarting the DB, which shouldn't be necessary, smithrn still gets in w/o any password checks. How come? Impossible to answer w/o knowing any entries in your

Re: [GENERAL] Requiring a password

2008-03-05 Thread Tom Lane
Andrej Ricnik-Bay [EMAIL PROTECTED] writes: On 06/03/2008, Ralph Smith [EMAIL PROTECTED] wrote: Even after reloading and restarting the DB, which shouldn't be necessary, smithrn still gets in w/o any password checks. How come? Impossible to answer w/o knowing any entries in your pg_hba.conf