psql --user myuser postgres
ALTER ROLE myuser WITH PASSWORD 'new_password';