Before install
sudo apt-get update
Install
sudo apt-get install postgresql postgresql-contrib
Change account to postgres
sudo -i -u postgres
Create new role
createuser --interactive
## or with sudo
sudo -u postgres createuser --interactive
Create new database
createdb dbname
## or with sudo
sudo -u postgres createdb dbname
Create user
sudo adduser username
Commands
Change postgres password
ALTER USER postgres PASSWORD 'password';