Change user password in PostgreSQL I created a user in PostgreSQL, gave it a password using:

alter user username with password 'new_password';


But when I try to login using phpPgAdmin, it keeps saying use/password incorrect, do I have to do something after alter password, like on MySQL where you have to run flush privileges?

Thanks.
No, no flush is needed.  The response given to the client is intentionally vague, to avoid disclosing information to a presumed attacker.  Look in the database server's log file for a more complete error message.