Shivender Devarakonda <shivenderd(at)gmail(dot)com> writes:
> I set the following property in postgresql.conf:
> client_encoding = UTF-8 # actually, defaults to database
That would not help if you were connecting to a database with SQL_ASCII
encoding (which defeats all encoding intelligence). I'd suggest
connecting to cmdb with psql and issuing an ALTER USER command to
set the user's password again.
regards, tom lane