smiley2211 <smiley2211(at)yahoo(dot)com> writes:
> Yep, I can connect LOCALLY with no problem...it's when I come through an
> application using this user that I have the connection issue.
Connect locally as superuser and issue an ALTER USER command to set the
user's password to whatever it should be.
regards, tom lane