Question: how to create database in postgresql in centos?
Answer: Connect to the PostgreSQL Shell sudo -u postgres psql.
Create a new PostgreSQL Role. The following command will create a new role named john: ... 
Create a new PostgreSQL Database. Create a new database named johndb using the createdb command: ... 
Grant privileges.