run shell - sudo -u [as user. default - postgres] psql postgres
create user for rails app - CREATE ROLE [name] WITH LOGIN SUPERUSER CREATEDB CREATEROLE PASSWORD 'password';
list all users - \du
set password - \password
list all databases - \l
use (connect) DB - \c db_name
drop DB - DROP DATABASE db_name;
drop user - DROP USER user_name;
quit - \q
copy data from one DB to another (NOT in postgres) - pg_dump -U illia hiker_development | psql -U illia hiker_production
restart postgreSQL - /etc/init.d/postgresql restart