Question: how to create postgres database on centos 7?
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.