Ubuntu and PostgreSQL

To create a new user:

sudo su postgres -c createuser

To change the password:

sudo su postgres -c psql postgres
ALTER USER *username* WITH PASSWORD '*password*';

To get complete information, please visit:
http://hocuspok.us/journal/postgresql-on-ubuntu-linux-how-to