In PostgreSQL, when a user forgets a password, you can change the user’s password with an authorized user using the following script.
1 | ALTER user xuser with password 'Asdf1234'; |
If you want to change your own password, you can change your password using the following command after connecting to PostgreSQL.
1 | \password |