Jeff Frost <jeff@frostconsultingllc.com> writes:
> Do you remember if the problem was on the 8.0.8 server side that caused the
> lack of prompting?
No, I'm pretty sure it was a client-side issue (and I thought we'd fixed
it by 8.0.8 anyway, so I'm glad to see your test agrees).
Jeanna, do you maybe have a pgpass file or something else that would
short-circuit the password prompt? It could be that your problem boils
down to supplying the wrong password behind-the-scenes.
regards, tom lane