ALTER USER postgres WITH PASSWORD 'new_password';sudo -u postgres psql \password postgresALTER USER username WITH PASSWORD 'new_password';sudo -u user_name psql db_name ALTER USER user_name WITH PASSWORD 'new_password';psql -U <superuser/privileged_user> -d <database_name>