ALTER ROLE postgres
WITH PASSWORD 'newpassword';