Simple steps to have a new user with a database in PostgreSQL/ArchLinux

PostgresSetupArchLinux.md

PostgreSQL setup in ArchLinux

Login as postgres user

$ sudo -u postgres -i

Create PostgreSQL user with login, password and permissions to create new databases

$ createuser -PWdE --interactive

Create database for newly-created user

$ createdb -U <username> <db-name>

Connect to database using newly-created user

$ psql -U <username> -d <db-name>

For more information visit: PostgreSQL - ArchWiki