Connecting to Postgress Shell
psql -U postgres -d postgres
List Users
select * from pg_shadow;
usename | usesysid | usecreatedb | usesuper | usecatupd | passwd | valuntil | useconfig
Change User Password
ALTER USER colin WITH PASSWORD 'letmein';
Reference: http://www.davidpashley.com/articles/postgresql-user-administration/
MANAGE POSTGRES
PhpPGadmin :
Install https://help.ubuntu.com/community/phpPgAdmin
No se puede logear: http://www.unixmen.com/install-postgresql-and-phppgadmin-on-debian-7-wheezy/
Usuario y Clave
ALTER USER postgres PASSWORD 'newPassword';