error: permission denied to create database

When using general users to create a database

PG::Error: ERROR: permission denied to create database

Solution¶

Login with postgres

sudo -u postgres psql
postgres=# ALTER ROLE xxxx CREATEROLE CREATEDB;
xxxx: common user name

Grant super authority

ALTER ROLE xxxx CREATEROLE SUPERUSER;