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
Post a Comment