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 vote172 views1 answer
Npm install quiet
Shell/Bash
5 votes197 views1 answer
Laravel installation from github
Shell/Bash
0 vote141 views1 answer
LibSSH Exploit
Shell/Bash
2 votes175 views1 answer
Ionic cordova sign apk
Shell/Bash
3 votes180 views1 answer
Terminal command uninstall android studio
Shell/Bash
0 vote178 views1 answer
Sudo apt-get install docker-ce docker-ce-cli containerd.io command not working
Shell/Bash
3 votes180 views3 answers
Git clone different name
Shell/Bash
1 vote221 views1 answer
Install stacer ubuntu or linux
Shell/Bash
0 vote193 views1 answer
YAML - Basic Cheatsheet
Shell/Bash
0 vote209 views1 answer
Dos view all files
Shell/Bash