Create a postgresql database

How to add postgresql user account

# adduser tom
# passwd tom

# sudo su -
(or might be # su - postgres)

$ psql -d template1 -U postgres

template1=# CREATE USER tom WITH PASSWORD 'myPassword';
template1=# CREATE DATABASE jerry;
template1=# GRANT ALL PRIVILEGES ON DATABASE jerry to tom;

template1=# \q

$ su - tom
$ psql -d jerry -U tom