[linux][postgres]

postgres@redwing-nb:/$ psql
psql (8.4.7)
Type "help" for help.

postgres=# \du
            List of roles
 Role name | Attributes  | Member of
-----------+-------------+-----------
 postgres  | Superuser   | {}
           : Create role  
           : Create DB    

postgres=# ALTER USER postgres WITH ENCRYPTED PASSWORD 'youepassword';

ALTER ROLE