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 vote151 views1 answer
Ubuntu taskbar center
Shell/Bash
1 vote153 views2 answers
Windows git ssh key add
Shell/Bash
1 vote279 views1 answer
View running jobs linux
Shell/Bash
0 vote143 views1 answer
Create next app with jest
Shell/Bash
0 vote164 views1 answer
Install latest golang on ubuntu
Shell/Bash
0 vote148 views1 answer
Git fatal "is in submodule"
Shell/Bash
1 vote102 views1 answer
How to revert a pr merge
Shell/Bash
0 vote154 views2 answers
Permission denied in /var/log in ubuntu
Shell/Bash
1 vote169 views2 answers
Install prettier globaly
Shell/Bash
13 votes205 views1 answer
Firewall not enabled (skipping reload)
Shell/Bash