$ sudo -u vagrant psql dbname
dbname=> \password
Enter new password:
Enter it again: 
dbname=>