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 vote98 views1 answer
Awk line range
Shell/Bash
4 votes120 views4 answers
Git squash
Shell/Bash
0 vote98 views1 answer
Mysql terminal
Shell/Bash
0 vote114 views1 answer
Pull Ubuntu image
Shell/Bash
0 vote67 views3 answers
Error: there are no scenarios; must have at least one.
Shell/Bash
0 vote103 views1 answer
How to run pyinstaller generate application in linux
Shell/Bash
36 votes68 views5 answers
Git remove submodule
Shell/Bash
9 votes151 views2 answers
How to ssh to another computer
Shell/Bash
24 votes123 views4 answers
Install imutils
Shell/Bash
2 votes100 views1 answer
Iis stop
Shell/Bash