When creating a database using a common user
PG:: error: error: permission denied to create database

Solution:
log in with Postgres
sudo – u Postgres PSQL

postgres=# ALTER ROLE xxxx CREATEROLE CREATEDB;

XXXX: common user name

Give super permission
alter role XXXX creator ole superuser