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.