Changing Password

1. Edit pg_hba.conf to allow trust authorization temporarily
2. pg_ctl reload to reload the config file
3. Connect and issue ALTER ROLE postgres WITH PASSWORD 'newpassword';
4. Edit pg_hba.conf again and restore the previous settings; pg_ctl reload again