Elite Frontier

PostgreSQL creates a postgres user for you. It’s simpler to create a new database user as superuser, for example using your user_name

su - postgresql
createuser --superuser your_username -U postgres

Now you can create your database

createdb my_database