CREATE DATABASE v14
CREATE DATABASE — Create a database.
CREATE DATABASE creates a database.
To create a database, you must be a superuser or have the
CREATEDB privilege. Normally, the creator becomes the owner of the new database. Non-superusers with the
CREATEDB privilege can create only databases they own.
The new database is a clone of the standard system database
The name of the database to create.
You can't execute
CREATE DATABASE inside a transaction block.
Errors along the line of “could not initialize database directory” are most likely related to insufficient permissions on the data directory, a full disk, or other file system problems.
To create a database: