CODE EXAMPLE FOR SQL

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