[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