Add user and database to postgresql

postgresql

How to create a postgres user and database.

Create postgres user

root@machine:~# su postgres
postgres@machine:~$ createuser --interactive --pwprompt

Add postgres database

root@machine:~# su postgres
postgres@machine:~$ createdb -O username databasename