postgres

install

sudo apt-get install postgresql sudo apt-get install pgadmin3

modify

/etc/postgresql/9.1/main/pg_hba.conf sudo service postgresql start/stop/restart

login

sudo su postgres -c psql template1 alter user postgres with password 'new_password'; sudo -u postgres psql

add user

sudo -c postgres psql \password create user new_user with password 'new_password'; create database new_db owner new_usera; \q

create role new_role with login password 'role_password'; create role new_role with createdb login password 'role_password'; create database my_application owner new_role; alter role new_role password 'new_passowrd';