PostgreSQL

PostgreSQL: Relevant Commands

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';

Leave a Reply

Your email address will not be published. Required fields are marked *