1. 1.Linux环境下  
2. #su  postgres   
3. -bash-3.2$psql -U postgres   
4. postgres=#alter user postgres with password ‘new password‘;  
5. postgres=#\q  

come from :http://blog.csdn.net/starnight_cbj/article/details/7332422

Postgresql 帐号密码修改方法