xxxxxxxxxx
SELECT rolpassword FROM pg_authid WHERE rolname = 'desired_username';
xxxxxxxxxx
for windows when you install you need to
specify the passord
for mac the password is your computer's password
note: if you don't specify then for windows and linux it's 'root'