Alterar password ao PostgreSQL no linux

Sem complicar:

# su postgres

$ psql

 

$ psql -U postgres

 

psql (8.4.7)

Type "help" for help.

postgres=#

 

postgres=# \password

Enter new password:

Enter it again:

postgres=#
Isto será o mesmo que executar a instrução:

ALTER USER postgres WITH ENCRYPTED PASSWORD 'MyNewPassword';