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 vote164 views1 answer
Get last element in an array bash
Shell/Bash
21 votes157 views4 answers
How to pip install tensorflow
Shell/Bash
0 vote245 views1 answer
Symfony5 bundle shema
Shell/Bash
3 votes176 views1 answer
W: some index files failed to download kali linux
Shell/Bash
0 vote161 views1 answer
Install rust ubuntu 20
Shell/Bash
0 vote177 views2 answers
Desinstalar paquetes ubuntu
Shell/Bash
1 vote222 views1 answer
Github drupalcomposer project
Shell/Bash
0 vote183 views1 answer
Gcloud set zone cli
Shell/Bash
1 vote168 views1 answer
Generate component angular without folder
Shell/Bash
19 votes195 views5 answers
Ubuntu list of users
Shell/Bash