create database from command line

Question

I´m trying to create a data base from command line. My OS is centos and postgres version is 10.9.

sudo -u postgres psql createdb test
Password for user test:

Why asking me by user?

Answer 1

follow the simple to create the database from command line:

• Switch the user to postgres by executing the following command :

                         su - postgres

• Creating the user

$ createuser userdemo

• Creating the needed Database

$ createdb demodatabase

•  Invoke the psql shell by

 

 

psql [password needed for postgressql]

 

• After that  you should provide access to the created user as

$ alter user userdemo with encrypted password 'Securix';

$ grant all privileges on database databasedemo to userdemo;