Ubuntu postgresql notes

psql.txt

# install database server
apt-get install postgresql libpq-dev

# install postgresql gem
gem install pg

# create postgres (super)user
createuser --superuser lsmith -U postgres

# change postgres user password
sudo -u postgres psql postgres
\password postgres

# create a database
sudo -u postgres createdb myDb

# database login
psql -d myDb -U username -W