postgres change password for postgres user code example
Example 1: alter user password postgres
ALTER USER user_name WITH PASSWORD 'new_password';
Example 2: reset password postgres ubuntu
\password sde
ALTER USER user_name WITH PASSWORD 'new_password';
\password sde