change postgres user password

ALTER USER postgres WITH PASSWORD '';