postgresql - Create database from command line -


i´m trying create data base command line. centos , postgres 9.2

sudo -u postgres psql createdb test password user test: 

why asking me user?

change directory postgres :

su - postgres 

acces postgres shell

psql ( enter password postgressql) 

create user postgres

$ createuser testuser 

create database

$ createdb testdb 

provide privileges postgres user

$ alter user testuser encrypted password 'qwerty'; $grant privileges on database testdb testuser; 

Comments

Popular posts from this blog

javascript - Bootstrap Popover: iOS Safari strange behaviour -

Website Login Issue developed in magento -

Can the constants be defined inside a model file of a framework in PHP? -