Postgres database create

Create postgres database

sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

Source: medium.com

Create database postgres

createdb -h localhost -p 5432 -U postgres testdb
password ******

Source: tutorialspoint.com

Similar codes

0 vote153 views1 answer
View a git log for a specific file
Shell/Bash
0 vote151 views1 answer
Ubuntu restart network manager when ping is low
Shell/Bash
11 votes152 views2 answers
Enable option in ubuntu to create document on right click
Shell/Bash
36 votes191 views6 answers
Import database mysql
Shell/Bash
0 vote163 views1 answer
Github howto contribute fork 2 commits behind
Shell/Bash
0 vote159 views1 answer
How to analyse a git repo
Shell/Bash
0 vote142 views1 answer
Gh clone
Shell/Bash
1 vote110 views1 answer
Linux delete files older than
Shell/Bash
13 votes153 views2 answers
Amend commit change description
Shell/Bash
0 vote149 views1 answer
How to uninstall global babel jest npm
Shell/Bash