Answers for "how to reset password for user in postgresql"

3

How to reset forgotten postgresql password

# sudo -u postgres psql
could not change directory to "/root"
psql (9.1.11)
Type "help" for help.

postgres=# \password
Enter new password:
Enter it again:
postgres=# \q
Posted by: Guest on May-02-2021
0

reset postgre password

$ sudo -u postgres psql

Then type

# ALTER USER my_user_name with password 'my_secure_password';
Posted by: Guest on February-28-2022

Code answers related to "how to reset password for user in postgresql"

Browse Popular Code Answers by Language