Setup PostgreSQL and manage it

Work In Progress

sudo -u postgres psql
sudo -u postgres psql -d db
ssh -NL 1111:localhost:5432 server
sudo -u postgres pg_dump -U postgres -F c -b -v -f db.backup db
CREATE USER username WITH ENCRYPTED PASSWORD 'password';
CREATE DATABASE db;
GRANT ALL PRIVILEGES ON DATABASE db to username;