Thanks Melvin for your investigation.
>Could it be you were enclosing the password in double, not single quotes >that caused the problem?
In fact i'm using single quote for password.
>1. Try connecting as user postgres, then DROP ROLE "MyRole";
>and recreate as above.
I just tested on Windows 7 and it works as expected.
But it gives the error on Debian Linux (64 bit)
>Verify you are currently logged in as user "MyRole"
>with
>SELECT CURRENT_USER;
Yes, i'm loggged in as "MyRole" user to change the password
using command : ALTER ROLE MyRole WITH PASSWORD 'myPassword';
but it gives : ERROR: cannot execute ALTER ROLE in a read-only transaction.
Do not understand why.
Thanks again.
Regards,
Ravi.