[root@dev ~]# su - postgres
-bash-4.1$ psql template1
psql (9.2.4)
Type "help" for help.
template1=# alter user postgres with password '********';
ALTER ROLE
template1=# alter user
template1-# \q
[root@dev ~]# su - postgres
-bash-4.1$ psql template1
psql (9.2.4)
Type "help" for help.
template1=# alter user postgres with password '********';
ALTER ROLE
template1=# alter user
template1-# \q