How to create new database and new user with password on PostgreSQL (the easiest way)

new-db-postgres.md

How to create new database and new user with password on PostgreSQL

First, create db:

$ createdb avocado

Then, create user:

$ createuser avocado

Then, login to psql with admin user (usually postgres) and change password of new user:

$ sudo -u postgres psql
psql (9.6.2, server 9.4.4)
Type "help" for help.

postgres=# \password avocado
Enter new password:
Enter it again:
postgres=# \q

Give create db permission to new user

$ sudo -u postgres psql
psql (9.6.2, server 9.4.4)
Type "help" for help.

postgres=# ALTER USER avocado CREATEDB;
ALTER ROLE
postgres-# \q